Interested to Buy Any Domain ? << Click Here >> for more details...
how to do pergformence tuning in datastage?
- 4 Answers
- 43690 Views
- MCA, Symphony, TCS, I also Faced
- E-Mail Answers
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
If you want to use the same piece of code in different jobs, how will you achieve it?
What is meta stage?
how to implement scd2 in datastage 7.5 with lookup stage
Define Job control?
in oracle target stage when we use load option and when we use upsert option?
What is orabulk stage?
What is datastage?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
Explain the importance of surrogate key in data warehousing?
client know skid info?
What could be a data source system?
If you want to use a same piece of code in different jobs, how will you achieve this?
what is the difference between == and eq in UNIX shell scripting?
why do u need the IOS upgradation in a FC switch
What are some prerequisites for datastage?
