Lookup Runs Slow

devidotcom · Post by **devidotcom** » Fri May 07, 2010 12:38 pm

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

chulett · Post by **chulett** » Fri May 07, 2010 12:50 pm

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.

devidotcom · Post by **devidotcom** » Fri May 07, 2010 12:52 pm

Yes.

For example:

Source Records
1 A B
1 A D
1 E P

One Reference Record only
1 PP

Output required
1 A B PP
1 A D PP
1 E P PP

The column with value 1 is the lookup key

devidotcom · Post by **devidotcom** » Fri May 07, 2010 1:41 pm

Any help on this issue..

nagarjuna · Post by **nagarjuna** » Fri May 07, 2010 1:49 pm

you mean to say that there will be only one record from reference link ?
what is the through put in primary link ?

devidotcom · Post by **devidotcom** » Fri May 07, 2010 1:55 pm

yes only one record in the reference link and the primary link is the link from the source table.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Sat May 08, 2010 1:34 am

Is that a sparse lookup ?

If there is only one record, why don't you fetch that in a separate job and pass as parameters to current one ?