In this article, we are going to explain, How to use Pre SQL and Post SQL in Informatica. Or, the steps involved in configuring the Pre and Post SQL in Source Qualifier Transformation with an example. For this Informatica Pre and Post SQL example, we are going to use the below show data (EmpDetails table) … Read more
The Source Qualifier Transformation in Informatica is an Active and Connected transformation. While creating a mapping, this is the default transformation generated by the power Center Designer. This Informatica Source Qualifier Transformation converts the source data types to the native data types. In real-time, you can use this Informatica Source Qualifier Transformation to Join Multiple … Read more
The Sequence Generator Transformation in Informatica is a connected transformation that generates numeric values. We can mainly use this transformation to generate primary keys and foreign keys or to fill or replace the missing primary keys with unique ones. The Sequence Generator Transformation in Informatica has two output ports, only NEXTVAL and CURRVAL, and it … Read more
The Lookup Transformation in Informatica is very useful for looking up data present in Flat Files, Relational tables, and Views. In this article, we will show you, How to perform the lookup operation on the SQL server database table using the Lookup Transformation in Informatica with an example. Before we start designing the Mapping, let … Read more
The Unconnected Lookup Transformation in Informatica is nothing but a programming function with parameters, and in order to call this unconnected lookup, we have to use the Expression transformation. In this article, we will show you, How to perform unconnected Lookup Transformation in Informatica with an example. Before we start designing the Mapping, let us … Read more
The Aggregator Transformation in Informatica is one of the most used transformations in real-time. This transformation performs a function similar to the SQL Server Aggregate functions. The Informatica Aggregator Transformation operations include the following: In this article, we explain the steps involved in configuring the Informatica Aggregator Transformation to perform a few of the above-mentioned … Read more
The Expression Transformation in Informatica is a passive transformation that is used to perform non-aggregate calculations on the source data. It means you can use this Informatica Expression transformation to perform calculations on a single row. For example, you are trimming the extra spaces, data conversions, string manipulations, etc. The following are some of the … Read more
The Union Transformation in Informatica combines data from multiple sources (excel files, flat files, etc.) or multiple SQL tables and produces one output to store in the target table. It is an active transformation, and it is similar to the SQL Union All. The Union Transformation in Informatica is very useful in real-time. For example, … Read more
The Router Transformation in Informatica is just like the IF condition or CASE statement. It will check the given condition, and based on the condition result, the output will be sent to the appropriate destination path. This is similar to Filter transformation, and we can use the Informatica Router Transformation when we have to test … Read more
The Informatica Rank Transformation is similar to SQL RANK function, which is used to select the Top or bottom rank of data. In this article, we are going to explain the steps involved in configuring the Informatica Rank Transformation with Group By along with an example. For this example, we are going to use the … Read more
