[resolved] FULL OUTER JOIN

One Star

[resolved] FULL OUTER JOIN

hi team,
I went through talend for last three weeks.But ia m not able to find how to implement FULL OUTER JOIN in talend open studio.
Plese any body help me have to implement FULL OUTER JOIN both in open studio and CDC(Change data capture).
That FULL OUTER JOIN technique should work for CDC also.
I implemented FULL OUTER JOIN usinf two LEFT OUTER JOINS.When i run simple job it is working fine.In CDC it is failing.

Accepted Solutions
Community Manager

Re: [resolved] FULL OUTER JOIN

Hello 
No a direct way to implement full outer join on one component, you need to do two left outer joins. For CDC table, try to read data from CDC table and cache them into memory with tHashOutput first, and then read the data from memory back with tHashInput in the next two Left Outer joins. 
----------------------------------------------------------
Talend | Data Agility for Modern Business

All Replies
Community Manager

Re: [resolved] FULL OUTER JOIN

Hello 
No a direct way to implement full outer join on one component, you need to do two left outer joins. For CDC table, try to read data from CDC table and cache them into memory with tHashOutput first, and then read the data from memory back with tHashInput in the next two Left Outer joins. 
----------------------------------------------------------
Talend | Data Agility for Modern Business