The "Table Settings" step allows you to customize various table settings. You can change all or some of the following settings:
- The key that should be used to compare the data between tables. This is useful when a table has no primary key or other unique indexes in Oracle.
- A where clause that should be used to filter the table data.
- Columns that should be excluded and not compared.
The following fragment is the xml generated when various table settings have changed:
<TablePairs>
<!--****************************-->
<!--**** custom pairs ****-->
<!--**** "EMPLOYEES" ****-->
<Pair Action="Include">
<LeftObject Name="EMPLOYEES">
<Key Name="e961d627-0688-4ee5-935c-4d49f133bbd2">
<Column>EMPLOYEE_ID</Column>
</Key>
</LeftObject>
<RightObject Name="EMPLOYEES">
<Key Name="0a96c224-a967-454e-b3f9-c9696ff49eaa">
<Column>EMPLOYEE_ID</Column>
</Key>
</RightObject>
<Columns Action="Exclude">
<ColumnPair>
<LeftColumn>HIRE_DATE</LeftColumn>
<RightColumn>HIRE_DATE</RightColumn>
</ColumnPair>
<ColumnPair>
<LeftColumn>TERM_DATE</LeftColumn>
<RightColumn>TERM_DATE</RightColumn>
</ColumnPair>
</Columns>
<WhereClause>EMPLOYEE_ID > 100</WhereClause>
</Pair>
<!--****************************-->
</TablePairs>