PowerExchange for MongoDB JDBC User Guide for PowerCenter

10.4.1
- 10.5.7
- 10.5.6
- 10.5.4
- 10.5

Back Next

Configuring a Source Join

You can use the Application Source Qualifier of the parent table to join multiple tables.

In the

Mapping Designer

, retain the source qualifier only of the parent table and manually delete the source qualifiers for the child tables.

Link the fields from the child tables to the parent source qualifier.

The following image shows an example mapping that contains the linked child tables with the parent source qualifier:

Double-click the

Application Source Qualifier

of the parent table.

The

Edit Transformation

tab appears.

The following image shows the

Edit Conditions

tab in the Application Source Qualifier Transformation type:

Click the

Edit Conditions

tab.

Click

Edit Join Conditions

To define a join condition for the tables using

Platform Expression

, perform the following tasks:

In the

Tables

section, select the child table, and then select the join type for the child table with the parent table.

In the

Relationships

section, define the relationship for the join.

The

Add

button in the

Relationships

section enables only when you select the child table.

The following image shows the join types that you can configure and the relationship that you can define to join tables when you use the Infa expression:

To define a join condition using

Native Expression

, select the fields and define a join query syntax:

The following image shows the fields that you add when you define the join query:

Rename Saved Search

Table of Contents

PowerExchange for MongoDB JDBC User Guide for PowerCenter

PowerExchange for MongoDB JDBC User Guide for PowerCenter

Configuring a Source Join

Configuring a Source Join