In the Data Replication Console, you can define an expression and virtual column once and reuse them in other tables. This practice helps you save time in implementing an expression across multiple tables.
On the
Map Tables
tab, select the mapped source table to which you previously added a virtual column.
Click the
Show Virtual Columns
icon button above the source tables filter field, or right-click the source table row and click
Show Virtual Columns
.
The
Virtual Columns for <table_name>
dialog box appears.
Select the virtual column that you want to reuse and click
Reuse
.
The
Reuse Virtual Column
dialog box appears.
In the
Schema/owner
field, enter the schema or owner name of the source tables in which you want to reuse the virtual column.
To filter the list of tables, enter the first few letters of the source table names in the
Filter
field.
For case-sensitive filtering, enclose the filter value in double quotation marks.
To show only the mapped tables, select
Show mapped tables only
.
Select the tables in which you want to reuse the virtual column.
To select all of the tables, click
Select All
.
To select tables individually, select the
Select
check box next to each table name.
If you want to deselect all of the tables, click
Clear All
. To deselect one or more tables individually, clear the