GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  DataStage

 Print  |  
Question:  Dataset and Transformers Performance

Answer: 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?


December 12, 2008 06:38:19 #1
 anurangevk   Member Since: December 2008    Total Comments: 1 

RE: Dataset and Transformers Performance
 

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

     

 

Back To Question