Whenever a connection's Properties are changed, the impact on the objects that use that connection must be considered.
Load tables have information from the connection stored within their Properties. This information is stored in the Load objects to minimize the complexity of the scheduled tasks.
The database link and database name are stored locally in each Load table. When either the database link or database name are changed on a connection, WhereScape RED displays the Update Associated Load Tables window.
Click Yes to automatically update the database link and/or database name on all associated Load tables.
This can also be done manually:
- Double-click the Load Tables object group in the left pane. This displays all Load tables in the middle pane.
- Select those Load tables that use the connection that has changed. Use the Windows standard keyboard keys (CTRL or SHIFT) for selecting multiple Load tables.
- Right-click to open a context menu and then select Change Connect/Schema.
- Select a different connection (e.g. Data warehouse) to change all the selected Load tables.
- Repeat step (3) and now change the tables back to the altered connection. This updates all the Load tables with the new connection information.