Interested to Buy Any Domain ? << Click Here >> for more details...
how to do pergformence tuning in datastage?
- 4 Answers
- 43377 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 are the devoleper roles in real time? plz tell i am new to datastage....
Explain usage analysis in datastage?
What are the different kinds of views available in a datastage director?
Give an idea of system variables.
How many types of stage?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
How the ipc stage work?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
How many Key we can define in remove duplicate stage?
What is the difference between orabulk and bcp stages?
Is it possible to query a hash file?
How to manage date conversion in Datastage?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
Why do we use link partitioner and link collector in datastage?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
