DSXchange

Hi,

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?

Thanks.

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.

If source and lookup are both Ora, why not do in db itself !!?

Search for Sparse and Performance.

I faced this problem several times (with DS Server).
Clearing the log reduced the startup time.

Pierre.

I concur with Ray on this. Server jobs are at your disposal. Use them for such jobs.

Sainath.Srinivasan wrote:If source and lookup are both Ora, why not do in db itself !!?

Search for Sparse and Performance.

Thanks ..in that case why use ETL itself if everything could be done efficiently in DB.!!

The "T" of ETL can rarely be done as efficiently or as flexibly in the database.