DSXchange

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.

Welcome aboard. Is this a server job (as marked) or a parallel job (as posted)? The answer will be different depending upon which it is.

It is server job version 7.5.3

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)

I am using teradata as main stage and ODBC as refrence stage . iam not using any hash file stage.Please provide me the solution.

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.

i have run the job it is fine inner join is happening but i am getting only one record instead of three records.

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.

thank you ray . I found the option in transformer stage and its working now.

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".

Please mark this thread as Resolved using green button at top.