Hi
I did a inner join using transformer stage with constraint as Not(Refrencelink.NotFound) i am geeting all the values which are matched .But in my refrence link i have 3 records with same key column i want all the three reords .The above condition is giving only one record which is matched for that key column but there are three records with same key column.
You marked this as a server job but placed it into the PX forum. From the question, I'll assume that this is indeed a server job. Since hashed files cannot have duplicate keys your reference cannot have 3 records with the same key column.
thank you i dont know where to post today only i joined in this forum.What can i do to get those records (i need to do inner join and all the three records needs to be loaded is it possible using transformer stage)
In this case the source or reference stage types are not relevant, server doesn't support this type of functionality. You can do this in PX jobs with the lookup or join stages, though.
As I stated in the previous post, server jobs output 1 row for each input row regardless of how many matches. It is a lookup stage and not a join stage.
Server DOES support this kind of functionality where the reference input is ODBC or UniVerse. Find the property called "allow multiple row return" in the Transformer stage properties and enable it.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Ray, as usual, is correct. I did a quick test/check but only on hashed files, then checked ODBC and didn't find the attribute and misremembered that it doesn't work, but now I've looked at the transform stage and see a tick box for "Reference link with multi row result set".
</a>