Examples of calculations are concatenating the first and last name adjusting the employee salaries converting strings to date etc.

Example of expression transformation in informatica. Transformation language functions are SQL-like functions that transform data. For example Sorter transformation. Expression Transformation in Informatica is a passive transformation can be used to calculate values in a single row.

Expression Transformation in Informatica is a connected and passive transformation number of input and output rows is the same which let you modify individual ports of a single row or add or suppress them. We can use the Expression transformation to. Joiner transformation is an active and connected transformation that provides you the option to create joins in Informatica.

For example you are trimming the extra spaces data conversions string manipulations etc. Expression transformation can also be used to test conditional statements before passing the data to other transformations. The TRUE result 1 is an integer and the FALSE result 3333 is a decimal.

A dynamic output port can return one or more generated ports. It also can be used to perform non-aggregate calculations. Must be a character string.

This transformation is used when a user wants to perform aggregate functions like sum average etc. Enter an expression in a port that uses the value of data from an input or inputoutput port. The Expression Transformation in Informatica is a passive transformation that is used to perform non-aggregate calculations on the source data.

Expression Transformation in informatica is a connected and passive transformation number of input and output rows is the same In this expression transformation we can calculate Row-Level calculations. Informatica transformation can be created using Designer tools such as Mapping Designer Transformation developer and Mapplet Designer then configure the transformation by adding ports properties groups expressions and son on and finally link the transformation to other transformation and target definitions by drag and drop method in the mapping or mapplet. The following are some of the operations achieved by the expression transformation.