In the previous practices, you created an interface with several sources to load the TRG_CUSTOMER datastore in the Oracle Sales Application model with the content of the
SRC_CUSTOMER table and the SRC_SALES_PERSON files from different models. Now you implement the lookup to load data in the target according to the age range provided in the
lookup table.
Note: Completing this practice is critical for all the following practice sessions.
Your Tasks:
1. Create an ODI Interface with a new lookup.
a. In the Designer, duplicate interface INT_9-1. Open the copy of INT_9-1 and rename the interface INT_9-2. Ensure that the Staging Area Different From Target check box is deselected. Click the Mapping tab.
b. In the Mapping tab, click the
button to arrange the datastores in the source pane.
In the Confirmation window, click Yes. Click the Add a new Lookup
icon.
c. In the Lookup Tables Wizard, select the SRC_CUSTOMER table in the Driving Table pane. In the Lookup Table pane, expand the HSQL_SRC model, and then select SRC_AGE_GROUP. For alias, enter LKUP_AGE_RANGE, and then click Next.
d. In the screen that follows, select the AGE column in the Source table pane. Select AGE_MIN in the Lookup pane, and then click the Join button.
e. Edit the lookup condition to read:
SRC_CUSTOMER_AGE BETWEEN LKUP_AGE_RANGE.AGE_MIN. Select AGE_MAX in
the Lookup pane, and then click the Join button again.
f. Edit the Lookup condition to read: SRC_CUSTOMER_AGE BETWEEN LKUP_AGE_RANGE.AGE_MIN AND LKUP_AGE_RANGE.AGE_MAX. Click Finish.
SRC_CUSTOMER table and the SRC_SALES_PERSON files from different models. Now you implement the lookup to load data in the target according to the age range provided in the
lookup table.
Note: Completing this practice is critical for all the following practice sessions.
Your Tasks:
1. Create an ODI Interface with a new lookup.
a. In the Designer, duplicate interface INT_9-1. Open the copy of INT_9-1 and rename the interface INT_9-2. Ensure that the Staging Area Different From Target check box is deselected. Click the Mapping tab.
b. In the Mapping tab, click the
button to arrange the datastores in the source pane.In the Confirmation window, click Yes. Click the Add a new Lookup
icon.c. In the Lookup Tables Wizard, select the SRC_CUSTOMER table in the Driving Table pane. In the Lookup Table pane, expand the HSQL_SRC model, and then select SRC_AGE_GROUP. For alias, enter LKUP_AGE_RANGE, and then click Next.
d. In the screen that follows, select the AGE column in the Source table pane. Select AGE_MIN in the Lookup pane, and then click the Join button.
e. Edit the lookup condition to read:
SRC_CUSTOMER_AGE BETWEEN LKUP_AGE_RANGE.AGE_MIN. Select AGE_MAX in
the Lookup pane, and then click the Join button again.
f. Edit the Lookup condition to read: SRC_CUSTOMER_AGE BETWEEN LKUP_AGE_RANGE.AGE_MIN AND LKUP_AGE_RANGE.AGE_MAX. Click Finish.
No comments:
Post a Comment