All,
How can you join three tables at a time?
Why can't we use a [B]Single [COLOR="DarkRed"]Joiner Transformation [/COLOR][/B]to join three tables at a time ?
Sanghala
Printable View
All,
How can you join three tables at a time?
Why can't we use a [B]Single [COLOR="DarkRed"]Joiner Transformation [/COLOR][/B]to join three tables at a time ?
Sanghala
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.
[COLOR="Blue"]Really good question(requirment)[/COLOR] to [COLOR="blue"]Informatica Tech Support[/COLOR], [COLOR="Sienna"]Please ask them to ease them in the next version.[/COLOR]
[B]TAKE IT EASY[/B]
[QUOTE=N SRIRAM K]Two join three tables (which are originated from same database) then use single source qualifier transformation.
[COLOR=Blue]Really good question(requirment)[/COLOR] to [COLOR=blue]Informatica Tech Support[/COLOR], [COLOR=Sienna]Please ask them to ease them in the next version.[/COLOR]
[/QUOTE]
Yep this Question was atlleast not updated by any one as i have asked many of my friends.
[QUOTE=N SRIRAM K]If they are not homogeneous sources then use two different joiner transformations.[/QUOTE]
But I donot want to use multi Joiner Transformations
But in Infa 7.1 version, some option is there to do this.
Let me get it by reading the Help of Infa itself..........!
I will try from my side.
Let me know if you get it.
Thanks.......................
[QUOTE=N SRIRAM K]I will try from my side.
Let me know if you get it.[/QUOTE]
As per my investigation, This is done by [B]CUSTOM Transformation[/B] which is available from INFA 7.1 version.
If it is not correct.... Please make it perfect...!
G R E A T. I thought its not possible but you did it.
Its great help if you explain.............Thx
Joiner are basically used to join the hetrogeneous data Source
You can join the three tables using Joiner transformation proivded that the condition should be mention in Joiner properties