Lookup on the same table twice
Posted: Tue Jul 03, 2007 11:14 pm
Hi,
I have a scenario where in I want to look up on the same table twice. So I have used a LoopUp stage with two oracle stages connected to it lets say ora_table and copy_ora_table both representing the same table ora_table. The first Lookup on the ora_table doesnt have any problem. But I am not getting the desired output from copy_ora_table.
Is there anything I am missing out on understanding lookup stages.
I have a scenario where in I want to look up on the same table twice. So I have used a LoopUp stage with two oracle stages connected to it lets say ora_table and copy_ora_table both representing the same table ora_table. The first Lookup on the ora_table doesnt have any problem. But I am not getting the desired output from copy_ora_table.
Is there anything I am missing out on understanding lookup stages.