Its the first and basic transformation used in Informatica power center tool. Expression transformation is connected and Passive transformation used to calculate values on a single row. It is used for concatenating first and last names, conversion of strings to date, used for conditional statements and so on.
Steps to create an expression transformation :-
- In the mapping designer, create a new mapping or open an existing mapping.
- Go to Toolbar->click Transformation -> Create. Select the expression transformation.
- Enter a name, click on Create and then click on Done.
- You can add ports to expression transformation either by selecting and dragging ports from other transformations or by opening the expression transformation and create ports manually.
Steps to create an expression transformation :-
- In the mapping designer, create a new mapping or open an existing mapping.
- Go to Toolbar->click Transformation -> Create. Select the expression transformation.
- Enter a name, click on Create and then click on Done.
- You can add ports to expression transformation either by selecting and dragging ports from other transformations or by opening the expression transformation and create ports manually.
No comments:
Post a Comment