All,
How can you join three tables at a time?
Why can't we use a Single Joiner Transformation to join three tables at a time ?
Sanghala
All,
How can you join three tables at a time?
Why can't we use a Single Joiner Transformation to join three tables at a time ?
Sanghala
Sanghala
If you are satisfied with my reply. Please click “Thanks” button which increases the reputation and can serve you better.
Two join three tables (which are originated from same database) then use single source qualifier transformation.
If they are not homogeneous sources then use two different joiner transformations.
Really good question(requirment) to Informatica Tech Support, Please ask them to ease them in the next version.
TAKE IT EASY
Thx
SRIRAM N
Hope Everything Good
Yep this Question was atlleast not updated by any one as i have asked many of my friends.Originally Posted by N SRIRAM K
But I donot want to use multi Joiner TransformationsOriginally Posted by N SRIRAM K
But in Infa 7.1 version, some option is there to do this.
Let me get it by reading the Help of Infa itself..........!
Last edited by admin; 05-31-2013 at 07:22 AM.
Sanghala
If you are satisfied with my reply. Please click “Thanks” button which increases the reputation and can serve you better.
I will try from my side.
Let me know if you get it.
Thanks.......................
Thx
SRIRAM N
Hope Everything Good
As per my investigation, This is done by CUSTOM Transformation which is available from INFA 7.1 version.Originally Posted by N SRIRAM K
If it is not correct.... Please make it perfect...!
Sanghala
If you are satisfied with my reply. Please click “Thanks” button which increases the reputation and can serve you better.
G R E A T. I thought its not possible but you did it.
Its great help if you explain.............Thx
Last edited by N SRIRAM K; 09-06-2007 at 10:04 AM.
Thx
SRIRAM N
Hope Everything Good
You can join the three tables using Joiner transformation proivded that the condition should be mention in Joiner properties