Interested to Buy Any Domain ? << Click Here >> for more details...
how to do pergformence tuning in datastage?
- 4 Answers
- 43896 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
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
Define APT_CONFIG in Datastage?
Whats difference betweeen operational data stage (ods) and data warehouse?
What is "fatal error/rdbms code 3996" error?
Differentiate between odbc and drs stage?
what is use of SDR function?
What are the functionalities of link partitioner?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
How to read the length of word in unix?
What are the different options associated with dsjob command?
What is usage analysis in datastage?
Triggers,VIEW,Procedures
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
