Cascading Joins
Posted: Thu Oct 07, 2004 6:05 am
Hi All,
I dont know if i can explain this.
I have three table T1, T2, T3.
Relations
T1 and T2 are related on column A (like T1.A = T2.A )
T2 and T3 are related on column Z (Like T2.z = T3.z)
Now,
When In datastage i join the T1 and T2 on A using Join Stage and then the o/p from this join stage is connected to another Join stage with T3 on Z, i do not get the correct result.
I tried the other way as well . T2 joined on T3 and then the o/p joined on T1. Still wrong.
Its like whatever T2 is joined with first, for that stage i get the o/p correct, but fails when it is joined in the second Join stage.
Any ideas as to why is this strange behavior ?
I have looked into LINK Ordering, Partioning and things like that.? NO GO !!
Any help ???
Regards
pankaj[/img]
I dont know if i can explain this.
I have three table T1, T2, T3.
Relations
T1 and T2 are related on column A (like T1.A = T2.A )
T2 and T3 are related on column Z (Like T2.z = T3.z)
Now,
When In datastage i join the T1 and T2 on A using Join Stage and then the o/p from this join stage is connected to another Join stage with T3 on Z, i do not get the correct result.
I tried the other way as well . T2 joined on T3 and then the o/p joined on T1. Still wrong.
Its like whatever T2 is joined with first, for that stage i get the o/p correct, but fails when it is joined in the second Join stage.
Any ideas as to why is this strange behavior ?
I have looked into LINK Ordering, Partioning and things like that.? NO GO !!
Any help ???
Regards
pankaj[/img]