We will talk about the steps needed to create a lookup transformation:
- In the Mapping Designer, click on Transformations, and create Lookup transformation. Specify the name of the Lookup transformation, and click on OK.
- A new window will ask you to select the source, target, or Source Qualifier on which you wish to look up. You will get a list of all the sources, targets, and Source Qualifier available in your Repository. Click on the required component and then on OK as shown in the following screenshot:
If the required source or target is not available in the Repository, you can import it before ...