Create a compareset, which includes the database connection profile, and the source and target tables to be compared.
Prerequisites
Verify that you have created an agent connection.
Task- In the Perspective Resources view, select a Data Assurance server.
- Select .
- Expand Data Assurance Server, then select
Data Assurance Comparesets.
- Either:
- Select , or,
- Click the button that appears when you select Data Assurance Comparesets, then click Create Compareset.
- Specify the compareset basic information, and click Next or Source Table.
Field |
Description |
Data Assurance server |
(Required) Name of the DA server from the drop-down list. |
Name |
(Required) Name of the compareset.
|
Description |
A brief description to help you identify the compareset.
|
- Select from existing database connections or click New to create a new one.
- Select a schema and a database table.
- Select the columns to compare.
- (Optional) Specify contraints to control the comparison job.
- Click Next or Target Table(s).
- Repeat the same steps performed for the source table.
- (Optional) Click Add Target to define a new target table to compare with the source table.
Note: You can compare a source table to one or more target table.
- Click Finish.