Fields
and controlsUse the Change Source window to change the warehouse source for your step without removing the source link from the process model and adding a new link. You can change the warehouse source of any step in development or test mode that has a target table. You can make the following types of changes to the warehouse source:
Replace the existing warehouse source for the step
Add a warehouse source to a step without a warehouse source
Add source tables to the step
Remove source tables from the step
If any source tables being removed are used in the SQL for the step, the Data Warehouse Center displays a warning message that the source tables will be removed from the SQL.
When you change a source table, the definition of the step is modified to reflect the use of the new warehouse source and tables. Any SQL generation statements, joins, WHERE clauses, and GROUP BY HAVING clauses that specified the old source are deleted. To view these changes, open the SQL Step notebook.
To change the warehouse source, you must belong to a group that has access to the warehouse source.
To change or link to a source:
From the Available warehouse sources list, select the warehouse source that you want to use.
Click >. The selected warehouse source moves to the Selected warehouse sources list.
Click >> to select all the available warehouse sources.
Click OK.
The Data Warehouse Center creates a link between the warehouse source and the step in the Process Model window.
Related information
Defining a relational warehouse source
Authorities
and privileges