Inner Join in ServerEdition
Posted: Thu Oct 25, 2007 10:13 am
Hi
How we can implement the inner join in the ServerEdition. I got a business requirement as a Sql Query. I implemented the same query in the DS ServerEdition by using 2 DRS stages as source and one Transformer. I joined single column in the Transformer, Based on the join i derived some columns from Stream Link and Some columns from Reference Link.
Job is completed but i got a different output.
From the Reference Link I am getting 6000 Records from the Stream Link I am getting 45000 Records after performing join operation it's producing 45000. That output is not matching with the SQL Query which i run in the database. I understand my is performing LeftOuter join.
How can I Achieve inner join operation by using Transformer.
Thanks
How we can implement the inner join in the ServerEdition. I got a business requirement as a Sql Query. I implemented the same query in the DS ServerEdition by using 2 DRS stages as source and one Transformer. I joined single column in the Transformer, Based on the join i derived some columns from Stream Link and Some columns from Reference Link.
Job is completed but i got a different output.
From the Reference Link I am getting 6000 Records from the Stream Link I am getting 45000 Records after performing join operation it's producing 45000. That output is not matching with the SQL Query which i run in the database. I understand my is performing LeftOuter join.
How can I Achieve inner join operation by using Transformer.
Thanks