veer.dwh

 Profile Answers by veer.dwh Questions by veer.dwh

• Sep 18th, 2009

 

To improve DS job performence we can fallow sertain techniques

If it is PX job we can use pipeline or data partition techniques to run single job into multiple instance based on server configuration to gain good performence in DS.

--->You can eliminate unwanted data  as soon as possible in job design to eliminate unwanted data processing
--->you can eliminate unwanted columns bcz each unwanted column requires extra cpu memory
--->you can use sertain sorting techniques in job design to improve job performance
--->you can eliminate unwanted datatype conversions in job design bcz each unwanted type conversion will take extra time to finish the job.

These all techniques will help you to gain good performance in DS job design.

Regards,
Veeru.