How to improve performance..
Posted: Thu Oct 08, 2009 11:34 pm
Hi All,
Plese advice ,Which is best way to use the stage to get the optmum performance.
1-Currently I am using remove duplicate stage to remove the duplicate records,but i think using of sort stage is better to do the same operation..
Please suggest..Can I achieve any performance improvement out of that..Please advice
2-Transformer and filter stage:Currently am using filter stage ,If i replace it with transformer (using DS8x) can i expect any performance imrovement?..Please advice
3-During my loading process am creating N nubber of datasets,The same datasets will get overwrite in next run.The questing here is Can I expect any prformance improvemnt,If I delete the Datasets using orchadmin delete command after each run,Insted of overwrite though job.?Please give me your comments/suggestions
3-In most of the jobs ,I am crating 10-20 datasets in a final transformer and also that is a reject out put after a look up,Now the process looks very sow..Please advise..?
Plese advice ,Which is best way to use the stage to get the optmum performance.
1-Currently I am using remove duplicate stage to remove the duplicate records,but i think using of sort stage is better to do the same operation..
Please suggest..Can I achieve any performance improvement out of that..Please advice
2-Transformer and filter stage:Currently am using filter stage ,If i replace it with transformer (using DS8x) can i expect any performance imrovement?..Please advice
3-During my loading process am creating N nubber of datasets,The same datasets will get overwrite in next run.The questing here is Can I expect any prformance improvemnt,If I delete the Datasets using orchadmin delete command after each run,Insted of overwrite though job.?Please give me your comments/suggestions
3-In most of the jobs ,I am crating 10-20 datasets in a final transformer and also that is a reject out put after a look up,Now the process looks very sow..Please advise..?