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
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
Can you highlight the main features of ibm infosphere information server?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
What are system variables and sequencers in datastage
what is ds administrator used for?
How complex jobs are implemented in datstage to improve performance?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
What are orabulk and bcp stages?
What are the features of datastage flow designer?
EXPLAIN SCD
Have you have ever worked in unix environment and why it is useful in datastage?
Explain datastage architecture?
What is aggtorec restructure operator?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
Describe link sort?