We have a job with src as Oracle table with 6 lookup stages(In memory) , followed by the Transforer for the business rules and then loads an Oracle table. It gets roughly 2k records
Ths job takes startup time as 2.06 mins and 0.21 mins as production run time.So almost 90% of the time is used for Startup.
Any way by which I can reduce on the this startup time by making some design changes or any other settings that can help?
One of the major invisible things in version 8.0 is reduced startup time. There's not a whole lot you can do about it in version 7. That's one of the reasons I advocate server jobs for small to medium loads.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.