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.
Lookup on the same table twice
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 33
- Joined: Sun Jun 24, 2007 9:46 pm
-
- Participant
- Posts: 612
- Joined: Thu May 03, 2007 4:59 am
- Location: Melbourne
Re: Lookup on the same table twice
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. .
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>