Use the Process Model window to add a target to a process. Ordinarily, the Data Warehouse Center creates the target tables for a process when you promote the steps in the process to test status. However, you can use existing target tables in your data warehouse, and use the Data Warehouse Center to refresh those tables.
To specify that the Data Warehouse Center create a target table:
Right-click the step for which to create the target table.
Click Properties. The Step notebook opens.
Click the Parameters tab.
Select the Create Warehouse Target Table based on Parameters check box.
Select the name of the warehouse target from the Warehouse target list.
To add an existing target to a process:
Click the Data icon 
.
The Add Data window opens.
In the Available sources list, expand the targets tree by clicking the plus sign next to the Targets folder.
A list of the targets in the warehouse is displayed.
Expand the tree for a particular target by clicking the plus sign in next to the source.
Tables and files folders are displayed.
Expand the tree underneath the Tables or Files folder by clicking the plus sign in front of the Tables or Files folder.
A list of the tables or files for the warehouse target is displayed.
Select the table or file to add to the process.
Click >.
The table or file is added to the Selected sources list.
To add all the tables or views for a target to the process, select the tables or files folder and click >>.
Click OK.
The tables or files that you selected are displayed on the canvas.
Click Process --> Save to save the changes that you have made to the process.
Related information