Define the Datasets in odi

Define the Datasets

A dataset represents the data flow coming from a group of datastores. Several datasets can be merged into the interface target datastore using set-based operators such as Union and Intersect. The support for datasets as well as the set-based operators supported depend on the capabilities of the staging area's technology.
You can add, remove, and order the datasets of an interface and define the operators between them in the DataSets Configuration dialog. Note that the set-based operators are always executed on the staging area.
When designing the integration interface, the mappings for each dataset must be consistent, this means that each dataset must have the same number of target columns mapped.
To create a new dataset:

1. In the Source Diagram toolbar click Add /Remove DataSet... to display the DataSet Configuration dialog.
   
2. Click Add New DataSet... A new line is added for the new dataset at the bottom of the list.
   
3. In the DataSet Name field, give the name of the new dataset. This name will be displayed in the dataset tab.
   
4. In the Operator field, select the set-based operator for your dataset. Repeat steps 2 to 4 if you wish to add more datasets.
   
5. Click Close.
   

To arrange the order of the datasets:

1. Select a dataset in the DataSet Configuration dialog.
   
2. Click the Up and Down arrows to move the dataset up or down in the list.
   

To delete a dataset:

1. Select a dataset in the DataSet Configuration dialog.
   
2. Click Delete.