Database Reference
In-Depth Information
Creating a Lookup transformation
Perform the following steps to create and configure a Lookup transformation:
1. In Mapping Designer, click on
Transformations
and create a Lookup transforma-
tion. Specify the name of the Lookup transformation and click on
OK
.
2. A new window will ask you to select
Source
,
Target
, or
Source Qualifier
that
you wish to look up. You will get a list of all the sources, targets, and source quali-
fiers available in your repository. Click on the required component and then click
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
you use it to look up. Click on the
Import
button to import the structure, as shown in the
preceding screenshot.
The Lookup transformation with the same structure as the source, target, or source qualifier
appears in the workspace.