how to do pergformence tuning in datastage?
Answer Posted / venugopal [patni]
1. By using hashfile stage we can improve the performance.
In case of hashfile stage we can define the read cache size
& write cache size but the default size is 128M.B.
2. By using active-to-active link performance also we can
improve the performance.
Here we can improve the performance by enabling the row
buffer, the default row buffer size is 128K.B.
3. By removing unwanted columns.
4. By selecting appropriate update actions.
5. In parallel by replacing transformer with copy or filter
stage we can improve the performance.Because if you are
using more than 5 transformers in a stage the performance
will degrade,so to avoid transformer you can use copy or
filter.
6. In server by using linkpartitioner,linkcollectoe & IPC
stages also we can improve the performance.
Is This Answer Correct ? | 20 Yes | 3 No |
Post New Answer View All Answers
How will you move hashed file from one location to another location?
What is orabulk stage?
What are sequencers?
How to convert RGB Value to Hexadecimal values in datastage?
What is active and passive stage?
Have you have ever worked in unix environment and why it is useful in datastage?
What all are the different way to run a job?
How do you remove duplicate values in datastage?
Explain the situation where you have applied SCD in your project?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
how to add a new records into source?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
Name the different types of Lookups in Datastage?
What is difference between join, merge and lookup stage?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...