Total Pageviews

Friday, 28 February 2014

Expression Transformation In Informatica



Expression Transformation In Informatica 


Type: Passive & Connected.

Expression transformation usually used to perform row-by-row processing from source to target/another transformation.

 It calculates value in single row that we can also store it in a variable.

It performs non-aggregate calculations such as Addition, Multiplication, UpperCase function etc..


Can also be used for conditional check for each row like IF, DECODE etc.

Complex expression can be handled efficiently by creating variables and then assigning value to another variable.


Ports:

Input
Output
Variable: Used to perform temporary calculations which will be stored in variable

Examples: Concatenating first_name & last_name,

                Average salary for each employee,
                Complex expression like calculating percentage etc..

Thanks for reading..
 
-Nitesh.
 

No comments:

Post a Comment