OMrun Help Online Manual for OMrun Version 4

Business Mapping


OMrun Data Object Icon

The generate button adopts to different status (green/red). If any changes are made to the queries or the business mapping, the generate button changes color to red. Before the test case can be executed, it needs to be generated predding the button.

Color Description
Green The queries A/B with the business mapping is up to date and the test case is ready to execute.
Red The queries A/B with the business mapping is out dated and the test case is not ready to execute.

There are two radio buttons, Update/Initial and BySequence/ByName. The buttons define how the business mapping is created (overwrite/update and sequence). The initial setting is "Update" and "By Sequence".

Function Description
Update The existing business mapping is not deleted. Changes applied to the query are added/inserted to the existing business mapping.
Initial The existing business mapping is deleted, a new business mapping based on the sequence definition is created.
By Sequence If the "Generate" button is pressed a new business mapping is generated using the sequence of the attributes from the query A to map to query B.
By Name If the "Generate" button is pressed a new business mapping is generated matching the same names of query A to query B.

Comparison

The comparison radio buttons "Inner", "Outer", "Left Outer" and "Right Outer" define how the comparison is conducted. The different types enables the user to select for matching keys only or to display matching and overlaping data from two different heterogenious sources.

The two check boxes "Text Pages" and "Allow Duplicates" are special extended functions to the existing standard comparison.

Comparison Description
Inner (A/B) Only records with matching keys from source A and B are visible in the test results. The record content of the matching keys is compared.
Outer (A/B) All existing records from source A and B are visible. The record content of the matching keys is compared where the record content of the non matching keys is listed as overlapping results.
Left Outer (A) All records from source A are visible. From source B only the record content of the matching keys is visible. The record content of the matching keys is compared where the record content of the non matching keys from source A is listed as overlapping results.
Right Outer (B) All records from source B are visible. From source A only the record content of the matching keys is visible. The record content of the matching keys is compared where the record content of the non matching keys from source B is listed as overlapping results.

Mapping

The business mapping helps to map data from source A to source B. The initial generated mapping is allways a 1:1 compare between the attributes. At least one of the attributes is defined as a key. There are many additional functions available described in the section below.

Comparison Description
Inner (A/B) Only records with matching keys from source A and B are visible in the test results. The record content of the matching keys is compared.
Outer (A/B) All existing records from source A and B are visible. The record content of the matching keys is compared where the record content of the non matching keys is listed as overlapping results.
Left Outer (A) All records from source A are visible. From source B only the record content of the matching keys is visible. The record content of the matching keys is compared where the record content of the non matching keys from source A is listed as overlapping results.
Right Outer (B) All records from source B are visible. From source A only the record content of the matching keys is visible. The record content of the matching keys is compared where the record content of the non matching keys from source B is listed as overlapping results.

Alias

Every available attribute on source A/B is shown in a drop down list and is selectable for an attribute mapping.


Rule

Everything possible to add between the select statement and the from statement is allowed to add in the rule field. All the generated variables (e.g. @A-Type) can be used as a placeholder in other rule rows.


Function

The function defines how the mapped attributes (AliasA/AliasB) are compared. There are three different funcion how the mapped attributes are compared.

Function Description
= Checks if the content of both attributes is 100% identical = true
% Checks if a nummeric value from two attributes deviate within defined ranges. (Hight/Low)
!= Checks if the content of both attribute is not identical = true

Function Block

The function defines how the mapped attributes (AliasA/AliasB) are compared. The function is related with the range settings "Low" and "Hight".
The attribute value from "Alias A" is rounded based on the value in "Rounding". 

Function Field Description
= Low The value in the field is the relative min. deviation (absolute value) allowed to pass a compare if the value of "Alias B" is within range.
% Low The value in the field is the relative min. deviation (percentage) allowed to pass a compare if the value of "Alias B" is within range.
!= Low The value in the field does not affect the test result.
= High The value in the field is the relative max. deviation (absolute value) allowed to pass a compare if the value of "Alias B" is within range.
% High The value in the field is the relative max. deviation (percentage) allowed to pass a compare if the value of "Alias B" is within range.
!= High The value in the field does not affect the test result.
Format Field Description
String Rounding The compare between the two attributes ends after comparing the amount of characters defined in the field. (e.g. Rounding 2 on string "Text is longer" affects "Te" only)
Numeric Rounding The compare between the two attributes is executed on the rounded numeric values based on the number defined in the field.

Checkboxes

With the check boxes it is possible to define a key, set additional attributes as info fields and activate/deactivate attributes for the result list. For the compare all attributes are converted into plain string or plain number formats. The matching mechanismn for the keys are running on the original format. To match keys a format conversion within the queries is needed in case of different data formats.

Checkbox Description
Key It is possible to define one to many keys. As a default value the first attribute is automatically defined as key. An attribute defined as key is not allowed to be marked as "Info" field. If a "Key" field is deactivated, the next active attribute is automatically set as "Key"
Info An attribute with the checkbox set as "Info" is compared and visible in the result file but does not affect the overall row result passed/failed.
Active The checkbox "Active" does define whether the attribute is compared and visible in the result file or not.

Test Data Source A/B

The example table contains test data from source A and source B. Some of the data does match, others containing different keys. The record for BMW does exists as a duplicate in source B.

The listed comparison examples below do show how the test results are affected with the different comparison type selections.

Example data

Inner Comparison (A/B)

The "Inner" comparison type does compare the recordes with matching keys only. It shows the result of the intersection set.

Intersection
Result

Outer Comparison (A/B)

The "Outer" comparison type does compare alle existing recordes from source A/B. It shows the result of the union set.

Union
Result

Outer Comparison (A/B) - Text Pages

The "Outer" comparison type with the special flag for "Text Pages" indicates that the sources under test are converted pdf documents or other text documents (converted with CogniView to flat files or similar products). The documents are compared row by row (unsorted) and show the result as a union set.

The comparison expects in the first column allways the page number, in the second column the key (normally the first 25 characters of a row string) and in the third column the text of a complete row.

If the text to compare is the same but not expected within the same page on document A and document B, it is possible to define a high/low range of how many pages the text can be out of alignment (e.g.High = 1 means a text in document A can be found on page 2 where document B contains the same text on page 3 because of a different character style) .

Result 1: Compare result with text differences on the same line within the same page range
Result 2: Compare result with text differences on the same line within pages out of alignment.

Union
Result 1
Result 2

Left Outer Comparison (A)

The "Left Outer" comparison type does compare alle existing recordes from source A with the matching records from source B. It shows the result (Result 1) of the matching data and the overlap from source A.

Left Outer Comparison (A) - Allow Duplicates

The "Left Outer" comparison type does compare alle existing recordes from source A with the matching records from source B including duplicates. It shows the result (Result 2) of the matching data including duplicates and the overlap from source A.

Left Outer
Result 1
Result 2

Right Outer Comparison (B)

 The "Right Outer" comparison type does compare alle existing recordes from source B with the matching records from source A. It shows the result (Result 1) of the matching data and the overlap from source B.

Right Outer Comparison (B) - Allow Duplicates

 The "Right Outer" comparison type does compare alle existing recordes from source B with the matching records from source A including duplicates. It shows the result (Result 2) of the matching data including duplicates and the overlap from source B.

Right Outer
Result 1
Result 2