Tag: Joiner

Source Qualifier – Full Outer Join

No Picture

Full Outer Join using Source Qualifier – ‘SQL Query’ Integration service support only Left & Right outer joins. We cannot perform Full outer join using ‘User Defined Join’ properties in SQ, you will get a database error. This…

Read More »

Source Qualifier – User Defined Join – Right Outer Join

No Picture

How to join two tables – Source Qualifier – User Defined Join – Right Outer ** Source Qualifier Transformation is the most efficient way to join two tables in the same Database ** There are two options available in SQ…

Read More »

Source Qualifier – User Defined Join – Left Outer Join

No Picture

How to join two tables – Source Qualifier – User Defined Join – Left Outer ** Source Qualifier Transformation is the most efficient way to join two tables in the same Database ** There are two options available in SQ…

Read More »

Source Qualifier – User Defined Join – Normal Join

No Picture

How to join two tables – Source Qualifier – User Defined Join ** Source Qualifier Transformation is the most efficient way to join two tables in the same Database ** There are two options available in SQ to join multiple…

Read More »

Joiner Transformation – Normal Join

No Picture

Joiner Transformation – Normal Join Let’s create a Mapping with a Joiner Transformation – Normal Join. We are going to join two tables JOB_ID1 & JOB_ID2 and create a target with the ports from two tables. Normal Join…

Read More »

Joiner Transformation Overview

No Picture

Joiner Transformation Overview Use the Joiner transformation to join source data from two related heterogeneous sources residing in different locations or file systems. You can also join data from the same source. The Joiner transformation joins sources with…

Read More »