Expression transformation is a passive
transformation that you can use to perform non-aggregate
calculations in a single row. You can also use the Expression
transformation to test conditional statements before you pass the results to a
target or other transformations. You can enter multiple
expressions in a single Expression transformation by creating an
expression for each output port.
Expression Transformation Ports
Input Receives data from upstream
transformations. Input ports provide values used in a calculation.
Output Provides the return value of the
expression. You enter the expression as a configuration option for the output
port. You can also configure a default value for each port.
Variable Used for local variables.
Advanced Properties for Expression Transformation
Tracing Level Amount
of detail that appears in the log for this transformation. You can choose
terse, normal, verbose initialization, or verbose data. Default is normal.
Scenario for Expression transformation
Calculate the new
salaries for employees after the 10% hike in salaries.
*In case of any questions, feel free to leave comments on this page and I would get back as soon as I can.
Create a Reusable expression transformation and in the 'Parameters' view you can add the parameters(only of string datatype)
ReplyDeleteHi I'm new to Informatica express
ReplyDeleteI was trying to create a simple mapping with the same expression as provided here.
But while checking 'truncate target table' in the properties tab of the target my source also gets truncated.
In informatica power center enterprise we have 'generate and execute sql' that creates the structure of the target table,same as the source(if the client and server is installed in the same machine) in the database.
Could you please provide the target loading step too(if the same table structure is used as source and target)?
I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in Informatica Powercenter 9.X Developer training, kindly contact us http://www.maxmunus.com/contact
ReplyDeleteMaxMunus Offer World Class Virtual Instructor led training on Informatica Powercenter 9.X Developer training. We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ trainings in India, USA, UK, Australlia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.
For Demo Contact us.
Nitesh Kumar
MaxMunus
E-mail: nitesh@maxmunus.com
Skype id: nitesh_maxmunus
Ph:(+91) 8553912023
http://www.maxmunus.com/