Lookup on the same table twice

[dsdeveloper123]

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.

[ArndW]

There is nothing that prevents you from looking up the same table twice. Please post in the correct forum (PX or Server) as they use lookups differently and also post what your "expected result" for the second lookup is and what you are actually getting.

[JoshGeorge]

You can definitly look up the same table in a Parallel job. You might want to explain the scenario as in what is your 'desired output from copy_ora_table' is and your look up conditions for that as well. .