Hi all,
I am running a job with source as MQ and target as teradata, between many transformations/business rules has been implemented. My question is, what are the parameters will affects the performance of the job.
How to tweak the performance of the job?
1. By tweaking some of the parameters in TPUMP side?
2. By tweaking some of the parameters in MQ side?
3. By pulling some other parameters into the job level?
Parameters for performance tuning
Moderators: chulett, rschirm, roy
Parameters for performance tuning
regards,
Rakesh
Rakesh
-
- Premium Member
- Posts: 197
- Joined: Sun Jul 15, 2007 11:45 pm
- Location: Prague
It would depend on various conditions. The job design itself is to be considered as it might be effecting the overall performance. Coming to teradata you might want to have a look at how the indexes have been created as upon loading data even from datastage it does effect the running time of the job. The hardware has a role in the peformance too.
i would say it really depends on the job was designed.
Teradata Certified Master.
i would say it really depends on the job was designed.
Teradata Certified Master.
Re: Parameters for performance tuning
Rakesh
You can get more information when you read Datastage Advanced developer guide.
You can get more information when you read Datastage Advanced developer guide.
rakesh.nc wrote:Hi all,
I am running a job with source as MQ and target as teradata, between many transformations/business rules has been implemented. My question is, what are the parameters will affects the performance of the job.
How to tweak the performance of the job?
1. By tweaking some of the parameters in TPUMP side?
2. By tweaking some of the parameters in MQ side?
3. By pulling some other parameters into the job level?