When tables are large, you might want to estimate the amount of time that a comparison will take before running a full comparison. To get an estimate, run a test comparison of a limited number of rows. For example, if there are 100 million rows in a table, you can run a comparison for the first million rows and then multiply that amount of time by 100.

To specify the number of rows compared

1. On the navigation pane, click Profiles.

2. In the list, click the name of the profile that is linked to the job (or select it, and then click edit (pencil) icon.

3. In the Profile Information section, Click Initial Compare.

4. Clear the Use Default toggle of the Limit Number of Input Rows parameter, and then type the number of rows that you want to compare.

5. After running the test comparison, change Limit Number of Input Rows back to the default for the full comparison run.