Redefining Table From Source or Target

Option Redefine Table from Actual Source/Target explores base table definitions in a source or target database and compares them with the table information in a channel. It then adapts (either adds, replaces or deletes) the table information in the channel to match the base table definitions by modifying the HVR_COLUMN repository table.

The Redefine Table from Actual Source option adapts the table information in a channel based on the base table definition in the actual source database. The Redefine Table from Actual Target option does the same but based on the base table definition in the actual target database.

The option is available on the Tables and Table Details pages.

Redefine Tables from Tables Page

Perform the following steps to redefine a table from the actual source or target databases:

The following steps describe how to redefine a table from a source database (Redefine Table > From Actual Source). The same steps apply to redefining the table against a target database (Redefine Table > From Actual Target).

1. On the left sidebar, click TABLES.

2. On the Tables page, select a required channel in the Channels selector. Only tables belonging to this channel will be displayed on the page.

3. Select the required table(s) from the list of available tables.

4. Click the More Options icon at the top right and select Redefine Table From Actual Source.

   

5. In the Redefine Table From Actual Source dialog, optionally select the Sensitivity options as applicable:

   • Ignore Different but Compatible Data Types. This option will not override the column data types in the channel definition that are different but compatible with the corresponding column data types in a source or target base table. For example, if a channel was defined using tables from a source database, and that channel definition was used to create target tables (for example, during refresh) in a different DBMS, then the data types may differ in the channel and the target DBMS due to the data type mapping. In this case, this option can be used when redefining a table from the target DBMS to avoid redefining the channel using the target DBMS data types.
   • Ignore Extra Columns in DB. This option will not add columns that exist in the actual database, but not in the channel, to the channel definition.

6. Click OK.
   

Redefine Tables from Table Details Page

Perform the following steps to redefine a table from the actual source or target databases:

The following steps describe how to redefine a table from a source database (Redefine Table From Actual Source). The same steps apply to redefining the table against a target database (Redefine Table From Actual Target).

1. On the left sidebar, click TABLES.

2. On the Tables page, to quickly find the required table, select the channel to which the table belongs in the Channels selector.

3. Click the required table name. This will open its Table Details page.

4. Click the More Options icon at the top right of the Columns panel and select Redefine Table From Actual Source.

   

5. In the Redefine Table From Actual Source dialog, optionally select the Sensitivity options as applicable:

   • Ignore Different but Compatible Data Types. This option will not override the column data types in the channel definition that are different but compatible with the corresponding column data types in a source or target base table. For example, if a channel was defined using tables from a source database, and that channel definition was used to create target tables (for example, during refresh) in a different DBMS, then the data types may differ in the channel and the target DBMS due to the data type mapping. In this case, this option can be used when redefining a table from the target DBMS to avoid redefining the channel using the target DBMS data types.
   • Ignore Extra Columns in DB. This option will not add columns that exist in the actual database, but not in the channel, to the channel definition.

6. Click OK.