Expression Transformation in Informatica

  • Updated
  • Posted in Programming
  • 3 mins read


Expression transformation is a linked, passive transformation used to calculate values on a single row. Examples of calculations are concatenating the primary and final identify, adjusting the worker salaries, changing strings so far and so forth. Expression transformation will also be used to check conditional statements earlier than passing the information to different transformations.

Creating an Expression Transformation

Just observe the under steps to create an expression transformation

  1. In the mapping designer, create a brand new mapping or open an current mapping.
  2. Go to Toolbar->click on Transformation -> Create. Select the expression transformation.
  3. Enter a reputation, click on on Create after which click on on Done.
  4. You can add ports to expression transformation both by choosing and dragging ports from different transformations or by opening the expression transformation and create ports manually.

Adding Expressions

Once you created an expression transformation, you may add the expressions both in a variable port or output port. Create a variable or output port in the expression transformation. Open the Expression Editor in the expression part of the variable or output port. Enter an expression after which click on on Validate to confirm the expression syntax. Now Click OK.

Expression Transformation Components or Tabs

The expression transformation has the next tabs

  • Transformation: You can enter the identify and outline of the transformation. You may make the expression transformation reusable.
  • Ports: Create new ports and configuring the ports.
  • Properties: Configure the tracing stage to set the quantity of transaction element to be logged in session log file.
  • Metadata Extensions: You can specify extension identify, knowledge kind, precision, worth and may create reusable metadata extensions.

Configuring Ports:

You can configure the next parts on the ports tab

  • Port identify: Enter a reputation for the port.
  • Datatype: Select the information kind
  • Precision and scale: set the precision and scale for every port.
  • Port kind: A port might be enter, enter/output, output or variable.
  • Expression: Enter the expressions in the expression editor.

Expression transformation examples

1. Create a mapping to extend the wage of an worker by 10 p.c?

Solution:
In the expression transformation, create a brand new output port (name it as adj_sal) and enter the expression as wage+wage*(10/100)

The expression might be simplified as wage*(110/100)

2. Create a mapping to concatenate the primary and final names of the worker? Include area between the names

Solution:
Just create a brand new port in the expression transformation and enter the expression as CONCAT(CONCAT(first_name,’ ‘),last_name)

The above expression might be simplified as first_name||’ ‘||last_name

Recommended Reading:


SQL Transformation in Informatica
Informatica Scenario Based Interview Questions with Answers
Lookup Transformation in Informatica
Aggregator Transformation in Informatica
Update Strategy Transformation in Informatica

If you want this text, then please share it or click on on the google +1 button.

Leave a Reply