Interested to Buy Any Domain ? << Click Here >> for more details...
how to do pergformence tuning in datastage?
- 4 Answers
- 43674 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
What is difference between symmetric multiprocessing and massive parallel processing?
Explain the situation where you have applied SCD in your project?
What is usage analysis in datastage?
How do y read Sequential file from job control?
Could anyone give brief explanation bout datastage admin
Why do you need stage variables?
Name the third party tools that can be used in datastage?
How a server job can be converted to a parallel job?
What is staging variable?
What are constraints and derivations?
How one source columns or rows to be loaded in to two different tables?
What all are the different way to run a job?
What are data elements?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
Differentiate between data file and descriptor file?
