DSXchange

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

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

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

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)

It is server job version 7.5.3

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