DataMigrator now allows you to build a single data flow that performs lookups into multiple tables using the DB_LOOKUP function without requiring explicit joins.
In the following example, DMORD is the primary source containing orders data, while DMCOMP and DMINV are the lookup sources. While DMORD contains store codes and product numbers, DMCOMP contains the store names for those store codes, and DMINV contains the product names for each product code.
Refer to the sample data flow DMLKUPS for the complete example.
For more information on improving lookup performance, see Improving Lookup Performance.
This example uses the DB_LOOKUP function to create two target transformations.
The Select Synonym window opens.
Select the dmstores synonym and click the Select button.
The Transformations window opens.
The Transformation Calculator opens.
The prototype for DB_LOOKUP appears in the Expression window and the Lookup window opens.
The Select Synonym dialog box opens.
When you have selected the columns, the Lookup window should appear, as shown in the following image.
The Lookup Field window opens.
The Lookup window opens, as shown in the following image.
The expression is completed in the Transformation Calculator window.
The Transformation Calculator should now appear as shown in the following image.
The STORENAME source transformation is added to the Transformations window.
Parameter |
Column Name |
---|---|
Lookup Synonym |
DMINV |
Source Column |
PROD_NUM |
Lookup Column |
PROD_NUM |
Return Value |
PRODNAME |
When the data flow run is complete, verify that the data was loaded properly by right-clicking the DMSTORES object, selecting Toggle, and clicking the Sample Data tab.
Note:
iWay Software |