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..
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