Performance Tunning Techniques in Parallel

ravibabu · Post by **ravibabu** » Fri Oct 12, 2007 12:14 pm

Hi All,

Pls tell me tunning techniques in PX job.

How to tunning the job.

As of now i am using source and target is below.

Delimeted file
Fixed lenth file
Oracle
DB2

Please advise me ....

Thanks and Regards,
Ravi Babu.B

ray.wurlod · Post by **ray.wurlod** » Fri Oct 12, 2007 2:21 pm

By tunning one can only assume that you wish to liquefy your jobs and store the same in casks or barrels.

How do you define "performance" in an ETL context? What are your key performance indicators? Why do you believe your job design to be sub-optimal? Do you believe that your databases (DB2 and Oracle) are optimally tuned for the tasks you want them to perform - or is their tuning a compromise between the requirements of ETL processing and those for other users?