Show TOC

Procedure documentationMapping Comparison Tables Locate this document in the navigation structure

 

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

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 as soon as you create the comparison object. For example, you specify the restriction Country="DE" when you create the comparison object.

For variable filters, you specify when you create the comparison object that a certain data field is to be used as a variable filter, for example the Country data field. The variable filters are displayed in the comparison instance, where you can specify values for them, such as Country="DE". This allows you to create multiple comparison instances for the same comparison object and specify different filter values for each – for example, Country="DE" for one comparison instance and Country="US" for another comparison instance.

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

For date and timestamp 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 object and, 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 of the comparison object, define the mapping by dragging the arrows provided between the tables 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.