Performance tuning for SCD Stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
RudreshEswarappa
Participant
Posts: 21
Joined: Wed Aug 29, 2007 1:33 am
Location: Bangalore
Contact:
Contact RudreshEswarappa

Performance tuning for SCD Stage

Post by RudreshEswarappa »

Hi All,

I have created a job with SCD stage. The target is ODBC Enterprise stage (For SQL Server). For around 50,000 records, it is taking 7+ minutes. Can we do any more tuning to make it less than that time?

Thanks in Adv.


Regards

Rudresh
Rudresh Eswarappa
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

How many SCD stages? You can always make the final stage (the fact table) a sequential file stage, and bulk load (the inserts) into SQL Server.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”