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 to export or import the jobs in .ISX file
Differentiate between Join, Merge and Lookup stage?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
What is ds designer?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
how to abort the job its matain duplicates?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
Why do we use exception activity in Datastage?
Describe stream connector?
What is the use of hoursfromtime() function in transformer stage in datastage?
How do you import and export data into datastage?
How many Key we can define in remove duplicate stage?
I have a few records just I want to store data in to targets cycling way how?
What are the steps needed to create a simple basic datastage job?