Show TOC

Procedure documentationMapping Data Fields

 

You specify which data fields in the tables in the first system you want to compare to the data fields in the tables in the second system, as well as which data fields are to be used as comparison keys. You assign a name to this mapping so that you can identify it later on.

When you create your comparison, you also create fixed and variable filters that you use to restrict the comparison:

  • For fixed filters, you specify the data field and the exact value of the filter. For example, you specify the restriction Country="DE" when you create the comparison.

  • For variable filters, you specify that a certain data field is to be used as a variable filter, for example the Country data field. Variable filters are displayed in the comparison, where you can specify values for them such as Country="DE". This allows you to create multiple comparisons using the same data, but specify different filter values for each. For example, you can enter Country="DE" for one comparison and Country="US" for another comparison.

You can also define variable filters for just one side of the data model. This is useful, for example, if the field to be used as a filter exists only in one source system.

For date and time stamp fields, you can define relative filters to show the delta values between comparison runs. You can use the $DELTA variable for this purpose. For example, CREATED_AT>='$DELTA' would consider all new source documents created since the last comparison run.

Prerequisites

  • You have created a comparison.

  • If you have created more than one table for each system, you have defined the foreign keys between the tables.

Procedure

  1. In the data model for the comparison, map the tables by dragging the arrows provided from left to right.

    A dialog box is displayed for each mapping.

  2. Enter the following data:

    • Tag Name: Enter a name for the mapping.

    • Comparison Key No.: You create at least one comparison key for the comparison and specify the sequence of the comparison keys.

      Enter 1, 2, 3, and so on, to define the sequence of the comparison keys.

      Enter 0 to select the data fields for the actual comparison.

  3. Variable Filter: Enter a value to indicate that the mapping is a fixed filter.

    Enter X to indicate that the mapping is a variable filter.

    If you do not want to use the mapping as a filter, leave the field empty.

  4. Save your entries.

Result

You have defined the mapping between the data fields of the comparison tables.

Now create the function module for the comparison.

More Information

Filters in Cross-Database Comparison

Relative Date Filtering