✍ Kashif M
Trends

Monday, 2 September 2013


Expression transformations in Informatica


By on September 02, 2013


You can use the Expression transformations to calculate values in a single row before you write to the target. For example, you might need to adjust employee salaries, concatenate first and last names, or convert strings to numbers. You can use the Expression transformation to perform any non-aggregate calculations. You can also use the Expression transformation to test conditional statements before you output the results to target tables or other transformations.


Note: To perform calculations involving multiple rows, such as sums or averages, use the Aggregator transformation. Unlike the Expression transformation, the Aggregator allows you to group and sort data. For details, see Aggregator Transformation.

Kashif
mkashu: Expression transformations in Informatica
Review : Kashif | Kashif
Update: September 02, 2013 | Rating: 4.5

Comment for "Expression transformations in Informatica"

0 comments

Post a Comment

Blog Archive