When V is checked, the I and O check boxes are grayed out. Use an Expression Transformation to derive the new attributes to change the inconsistent data into consistent format.Use Expression Transformations for any row-wise calculation, such as if you want to concatenate the names, get the total salary, and convert it to uppercaseĪn expression transformation is created with following types of ports.Ī transformation variable is created by creating a port and selecting the V check box. Informatica Expression Transformation Uses The transformation receives the data from the input port and sends the data out from output ports.Expression transformation can also be used to test conditional statements before passing the data to other transformations.Įxamples of calculations are concatenating the first and last name, adjusting the employee salaries, converting strings to date etc. Expression transformation is a connected, passive transformation used to calculate values on a single row.The Expression transformation accepts the row-wise data, manipulates it, and passes it to the target.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |