Wednesday, December 26, 2012

Expression Transformation


Explain about Expression Transformation

Expression Transformation
This is a connected and passive transformation. It allows you to calculate the expressions for each record. It is used to perform non aggregate calculations. An Expression transformation is used for calculations, string concatenations, converting string to numbers and also check conditional statements.
It allows you to add new ports.
An expression transformation supports to write expression either in variable ports or only in output ports
Use an expression transformation to derive the new attributes to change the inconsistent data into consistent format
An expression transformation is created with following types of ports

1. Input port (I)
2. Output port (O)
3. Variable port (V)



For an exercise on this transformation check this   http://prashanthobiee.blogspot.in/2012/12/exercise-to-implement-filter-rank-and.html





1 comment:

  1. I feel Informatica is a very useful tool and this post very properly and clearly highlights each and every thing.

    Informatica Read Soap API

    ReplyDelete

Related Posts Plugin for WordPress, Blogger...