Adding sources to a process

Use the Process Model window to add sources to a process. You add sources to a process to specify the data that is to be transformed in the process.

To add sources to a process:

1. Open the Process Model window.

2. Click . (the Data icon).

3. Click the canvas at the spot that you want to place the icons that represent the sources that you are adding to the process.

   The Add Data window opens.

4. In the Available sources list, expand the Warehouse Sources tree by clicking the plus sign next to the Warehouse Sources folder. A list of the sources in the warehouse is displayed.

   You can also select from the Warehouse Targets tree by clicking the plus sign next to the Warehouse Targets folder.

5. Expand the tree for a particular warehouse source or warehouse target by clicking the plus sign next to the warehouse source or warehouse target.

   Tables, Views, and Files folders are displayed.

6. Expand the tree underneath the Tables, Views, or Files folder by clicking the plus sign next to the Tables, Views, or Files folder.

   A list of the tables, views, or files for the warehouse source or warehouse target is displayed.

7. Select the table, view, or file to add to the process.

8. Click >.

   The table or view is added to the Selected sources list.

   To add all the tables, views, or files for a warehouse source or warehouse target to the process, select the Tables, Views, or Files folder and click >>.

9. Click OK.

   The tables, views, and files that you selected are displayed on the canvas.

10. Click Process --> Save to save the changes that you have made to the process.

Related information

Warehouse source

Glossary