DSXchange

I have a question relating to job performance, one of the job is doing a normal lookup directly from the oracle table to retrieve ID, there are over 9 million records in the table and this lookup causes the performance to decrease.
how can i increase the efficiency of this job?

Thanks

Use join instead of lookup keeping the inputs hash partitioned and sorted on join keys.

Regards,
Ankita

attu wrote:I have a question relating to job performance, one of the job is doing a normal lookup directly from the oracle table to retrieve ID, there are over 9 million records in the table and this lookup causes the performance to decrease.
how can i increase the efficiency of this job?

Thanks

Yes...If lookup isn't upto what you look for, go with the JOIN.
Also instead of directly lookup on Oracle table, you can try dumping the oracle table first, and then Join with this dumped file [if the table is more of a static one]

Thanks Vijay and Ankita