Suggest me how to deal with this JOIN?

[bond88]

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.

[ray.wurlod]

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.

[stuartjvnorton]

Sounds like you need to understand your data a bit better to figure out what you need from that data stream.