To edit lookup tables from within Transformation Designer:
From Transfer Desk, select a profile that has a transformation you have defined.
Click the Edit
button below the profile details. The Profile Designer
dialog is displayed for the selected profile.
From the relevant Profile Designer, click Edit next to the Transformation field. The Transformation
Designer is displayed.
In the TML Details section, the source and target fields referenced by the profile for the transfer of data are listed along
with the operation to be performed during the transfer.
To edit the lookup settings, click the value in the Operation column for a particular
source. Select Lookup from the
drop-down list.
In the Source column of the selected record, click the browse button. The
Lookup Settings dialog is displayed,
showing the settings and source element details.
Select the required settings for the lookup from the following fields:
Table
select the table containing the data to be looked up.
Column
select the column of the table that contains the required data.
Business Unit
select either of the automatic settings: Use value
from source or Use value from
target.
When value not in table
select Use the source value or
Fail the transformation.
In the Source Element section of the Lookup
Settings dialog, select a component within the payload elements.
Click OK to save
the changes. The Lookup Settings dialog is closed, and the
Transformation Designer dialog is redisplayed.
Repeat steps 5 to 8 for each source element in the TML Details for which you want to apply a lookup.
Click OK to save
the changes. The Transformation Designer dialog is closed.