full outer join in data services

[srini_cnu]

Hi,

How to use the fullouter join in data services. any place this full outerjoin tab is there in any transformation..?

Regards

Srini

[srini_cnu · Accepted solution]

Hi,

In "FORM TAB"  only join pairs like left & right outer joins. but am asking about full outer join. how work on this tab in FULL outer join.

@please explain clear in every join this "FromTab"

[Former Member · Accepted solution]

HI,

there is no full outer join in the From tab:
If you want do full outer join so you have to do like this.

in the from tab: t1 leftouter join t2 and write the join condition

next do t2 leftouter join t1 and write the join condition

leftouter join: in the first condtion--> it will pick the all records from t1 and matched records from t2

for the 2nd condition--> it is reverse.

this is my idea. please try this may be it will help you

[Former Member · Accepted solution]

Hi,

Do the as below:

Step 1: take 2 source tables and  map with query1 transform--> in the query transform, you can do leftouter join like  t1 left outer join and provide the join condition

Step2 : use same source table and map with another query transform ---> in the query transform , you can do the left outer join like t2 left outer join t1 and provide the join condition

once completed the above steps, take merge transform and map with query 1 and query 2

in the next step , take one more query transform and enable distinct option in the select tab.

final you can load the data into your target table

[severin_thelen]

Hey Srini,

that's is not possible in one query transformation.

Therefore you have to use 2 query transforms. Q1(t1 left join t2) and Q2(t2 left join t1). After that you could merge both query's and eliminate duplicated rows.

Otherwise you should can use the sql transform.

Regards

Severin

[Former Member]

Hi,

I think you have to join like the below in from tab on query transform.

t1 leftouter join t2 and t2 leftouter join t1.

try this.