Dataset and Transformers Performance

How can you say that performance will be improve if we make use of a dataset?
Why does the performance degrade when we use 4-5 transformers in a single job?

Questions by sundeepksk

Showing Answers 1 - 2 of 2 Answers

anurangevk

  • Dec 6th, 2008
 

1. Using Dataset - The storage method is internal to datastage, hence performance increases as less time is required to read from or write to a dataset
2. Transformers are very bulky with lot of functions inbuilt them, so usage of more transformers slows down the speed at which job executes

ashokmadduri

  • Jan 17th, 2009
 

Dataset are referring to control file due to this dataset will give fast performance while processing the data, if you use transformers in job, it should compile the C++ backend due to this datastage engine will get more pressure to handle transformer stage, if you use more number of transformers in a job

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions