Hi,
I have a simple job
Oracle Enterprise stage ---> modify stage --- >lookup with Oracle enterprise stage --->transformer--->oracle enterprise stage
The lookup runs really slow. The join is on one dummy value of 1 to fetch one value from the reference table. I can see the data tricle well till the modify stage. But the output of lookup stage is really slow. I have used entire partition on the reference link as we only have one record.
Please suggest what could be the problem with the code.
Thanks
Lookup Runs Slow
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 247
- Joined: Thu Apr 27, 2006 6:38 am
- Location: Hyderabad
Please clarify exactly what this is supposed to mean - "The join is on one dummy value of 1 to fetch one value from the reference table". Are you saying you are fetching the same (essentially) static value over and over from a database table?
Gory details and examples always appreciated.
Gory details and examples always appreciated.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 247
- Joined: Thu Apr 27, 2006 6:38 am
- Location: Hyderabad
-
- Participant
- Posts: 247
- Joined: Thu Apr 27, 2006 6:38 am
- Location: Hyderabad
-
- Participant
- Posts: 247
- Joined: Thu Apr 27, 2006 6:38 am
- Location: Hyderabad
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom