Interested to Buy Any Domain ? << Click Here >> for more details...
how to do pergformence tuning in datastage?
- 4 Answers
- 43333 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
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
What are the various kinds of the hash file?
What is quality stage?
If you want to use the same piece of code in different jobs, how will you achieve it?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
How do you reject records in a transformer?
What is the purpose of pivot stage?
How do you import and export the datastage jobs?
What is the method of removing duplicates, without the remove duplicate stage?
Define Merge?
What are the differences between datastage and informatica?
What could be a data source system?
How to read the length of word in unix?
How the ipc stage work?
To see hidden files in LINIX?
