Comparing Data – Sample Scenario

The topics in this scenario provide an overview of the functions and features of Compare and the basic processing flow. The sample scenario proceeds through the basics of selecting and comparing data, using example tables that correlate with tables from the sample database.

Note: The sample database table names contain the prefix “OPTIM_”. The table names used in examples in this scenario do not contain the prefix “OPTIM_”.

Use the comprehensive Help facility in Compare at any time to obtain more information about a specific topic or function. You can click Help from the menu in most dialogs or right-click and click What's This from the shortcut menu to obtain context-specific help. Help is also available by pressing F1.

Scenario Overview

The following scenario directs you through the process of comparing a set of relational data in a Source File, in this case an Extract File, to the data currently in a database.

The scenario is intended to represent a typical situation in which the Extract File represents the data as it existed before testing your application and the database tables represent the same data after testing the application.

Note: A sample Extract File is provided on the product CD. The data in the sample Extract File is similar to, but different from the data provided in the sample database. The Extract File name used for this scenario is PST0001.xf.

As you proceed through this scenario, you will learn the key functions for comparing data, including how to:

  • Create a Compare Request.
  • Specify the sources of data to compare.
  • Define a Table Map to match the tables being compared.
  • Define match keys.
  • Process the Compare Request and browse the results of the comparison.
  • Save the Compare Request.