I am getting data from different tables and schemas using Oracle connectors. My job contains 12-15 joins and at last before writing to a Oracle table this is the scenario, I want to join two tables I need the data from one table and whatever the columns I need from another stream. I am using right outer join. But unfortunately the data stream has than one record with same ID. So thats why right outer is returning more rows than whatever in the right table.
I need the rows whatever in the right table and columns from the data stream after so many joins.
Suggest me how to deal with this JOIN?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You're getting exactly what a right outer join is supposed to return.
Your options include removing duplicates upstream of the Join stage or filtering records downstream of the Join stage.
Your options include removing duplicates upstream of the Join stage or filtering records downstream of the Join stage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 527
- Joined: Thu Apr 19, 2007 1:25 am
- Location: Melbourne