How can we do Performance tuning?
Posted: Mon Sep 04, 2006 6:55 am
Hi,
I have a requirement in which there are about 4000 records in one file and 5212 records in another file. And i'm using merge stage to merge these two files on one id. But it is taking more time to load infact the datastage is strucking in the middle without giving even one error or warning.
I would like to know about how to tune this job to run faster?
OR
How can i do performance tuning in DS (Parallel)
I'm using sequential files,transformers,one merge and ODBC stages in my job.
Thanks in advance,
I have a requirement in which there are about 4000 records in one file and 5212 records in another file. And i'm using merge stage to merge these two files on one id. But it is taking more time to load infact the datastage is strucking in the middle without giving even one error or warning.
I would like to know about how to tune this job to run faster?
OR
How can i do performance tuning in DS (Parallel)
I'm using sequential files,transformers,one merge and ODBC stages in my job.
Thanks in advance,