Welcome Guest! Log in
Stambia versions 2.x, 3.x, S17, S18, S19 and S20 are reaching End of Support January, 15th, 2024. Please consider upgrading to the supported Semarchy xDI versions. See Global Policy Support and the Semarchy Documentation.

The Stambia User Community is moving to Semarchy! All the applicable resources have already been moved or are currently being moved to their new location. Read more…


Stambia offers the possibility to perform Exists / Not Exists operations in Mappings to filter datasets when performing integrations.

A dedicated operator is available in Mappings to do this natively and as simply as a drag and drop.

You can find in this article all the necessary to start making Exist / Not Exists operations.

Prerequisites:
  • Stambia DI Designer S19.0.0 or higher

 

Mapping Operator

Let's start with the following Mapping, which is a simple integration from a source table to a target table.

sourceAndTarget

We want to filter the customers loaded into the target table by selecting only the ones that exists in a third specific referential table.

sourceAndTargetWithReferential

To perform the Exists operation, simply drag and drop the column on which the comparison should be done from the source table into the referential table.

Then, choose the Exists / Not Exists Operator:

operator

 

Click then on Exists / Not Exists and make sure to select the operation you want to perform; in our case, Exists:

 

properties

 

That's all! If we execute now the Mapping, source data will be filtered automatically using our referential table.

 

About the graphical representation

You can see visually on which dataset the Exists / Not Exists is performed.

There are two side around the Exists / Not Exists operator: the side with the dotted line, and the side which is attached to the source set.

The dotted line side corresponds to the table that will be used to filter data, the table on which the Exists / Not Exists is performed.

The dataset attached side correspond to the source dataset, the one that will be filtered.

This is very important as it will impact the queries generated, make sure that you are using the Exists / Not Exists operator in the correct direction

 

Switching datasets

If you want to change the direction of the Exists / Not Exists operator, you can use the "Switch dataset" right click menu:

switchDatasets

This will switch both the datasets and the Exists / Not Exists operation will then be performed in the other direction.

 

 

Articles

Suggest a new Article!