how to do pergformence tuning in datastage?
Answer Posted / raji
1.Avoid using transformer stage for renaming some
columns.Because it will slow down the performance of the
jobs.. Try to use Copy stage for renaming the columns.
2.Take only the required columns during the table level
lookups. Remove all the unnessary columns
3.By using partioning technique. It depends on our
requirement. It will increase the performance as well
Is This Answer Correct ? | 29 Yes | 4 No |
Post New Answer View All Answers
What is orabulk stage?
What are the partitioning techniques available in link partitioner?
Difference between sequential file and data set?
What are the functionalities of link collector?
How you Implemented SCD Type 1 & Type 2 in your project?
Is it possible to query a hash file?
What are sequencers?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
How can we improve the performance in datastage?
Describe the main features of datastage?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
How to manage date conversion in Datastage?
Define Routines and their types?
What is the difference between datastage and datastage tx?
What are some prerequisites for datastage?