Creating Lookup Transformation – Informatica

  • Updated
  • Posted in Programming
  • 2 mins read


The steps to create a lookup transformation are bit completely different when in comparison with different transformations. If you need to create a reusable lookup transformation, create it within the Transformation Developer. To create a non-reusable lookup transformation, create it within the Mapping Designer. Follow the under steps to create the lookup transformation.

1. Login to the Power middle Designer. Open both Transformation Developer tab or Mapping Designer tab.
Click on the Transformation within the toolbar, after which click on on Create.

2. Select the lookup transformation and enter a reputation for the transformation. Click Create.

3. Now you’re going to get a “Select Lookup Table” dialog field for choosing the lookup supply, selecting lively or passive possibility. This is proven within the under picture:

4. You can select one of many under choice to import the lookup supply definition:

  • Source definition from the repository.
  • Target definition from the repository.
  • Source qualifier within the mapping (relevant just for non-reusable lookup transformation)
  • Import a relational or flat file definition because the lookup supply.

5. In the identical dialog field, you might have an possibility to decide on lively or passive lookup transformation. You can see this feature in purple circle within the above picture. To make the lookup transformation as lively, examine the choice “Return All Values on Multiple Match”. Do not examine this when making a passive lookup transformation. If you might have created an lively lookup transformation, the worth of the property “Lookup coverage on a number of match” shall be “Use All Values”. You can not change an lively lookup transformation again to a passive lookup transformation.

6. Click OK or Click Skip if you wish to manually add ports to lookup transformation.

7. For related lookup transformation, add enter and output ports.

8. For unconnected lookup transformation, create a return port for the worth you need to return from the lookup.

9. Go to the properties and configure the lookup transformation properties.

10. For dynamic lookup transformation, it’s important to affiliate an enter port, output port or sequence Id with every lookup port.

11. Go the situation tab and add the lookup situation.

Leave a Reply