Using Data Sets with ODI Interface 1

In this practice, you add a new data set to an interface. Building upon the interface INT_9-2 you created in Lesson 9, you will add a bulk feed of customer data from another system by adding another data set.
First, you make a copy of interface INT_9-2, naming the copy as INT_11-3. This copy includes the default data set you defined in INT_9-2.
Now you create a new data set, naming it BULK_CUST_DATA. For its source, you specify the TRG_BULK_CUSTOMER datastore from the Oracle Sales Application model.
You specify the UNION operator to unite this new source of data with the default data set that you specified in INT_9-2.
Next, you perform an execution simulation to preview the code that will be used for this new data set with the UNION operator.
Finally, you execute the interface and verify the rows inserted into the target table.


Note: Completing this practice is critical for all the following practice sessions.
Your Tasks:
1. Create an ODI interface with multiple data sets.
a. In the Designer, right-click interface INT_9-2 and then duplicate it. Open the duplicate interface and rename it INT_11-3.Open the Mapping tab.




b. To arrange tables, click the Perform Layout icon , and then click Yes. Click the “Add/Remove DataSet” icon , and then click “Add new DataSet”





c. Enter the new data set name: BULK_CUST_DATA. Select Operator: UNION. Close the DataSets Configuration window.


d. In the Mapping tab, select the BULK_CUST_DATA data set tab. In the Models tab,drag the TRG_BULK_CUSTOMER datastore from the Oracle Sales Application to the Source area of the interface. Click Yes to perform automatic mapping.