Performance improvement - lookup with tmap

[vidya821]

Dear All,

I am using tmap to lookup two dfferent databases and using exp i am narrowing the lookup values however i am getting a performance of just 7-8 rows per sec.

I want to process around 1 Million records.

Attached is the design, is there anything more than can be done to improve performance.

Note: All indexes are in place.

Thanks

Vidya

[vidya821]

Thanks Rhall,
Yes indeed its same db tables in the job as of now, but the lookup table is going to change in future, the table is gonna be from diff db. Will see the workaround..