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.

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

2405

---

What are the enhancements made in datastage 7.5 compare with 7.0?

1095

---

Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

1140

---

describe the Steps to confiure a Qlogic switch

2329

---

If you want to use the same piece of code in different jobs, how will you achieve it?

1097

---

Define meta stage?

1144

---

i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

3701

---

Can you filter data in hashed file?

3724

---

What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

2045

---

How a source file is populated?

1020

---

EXPLAIN SCD

1341

---

What all the types of jobs you developed?

1115

---

What are stage variables and constants?

1098

---

table actions available in oracle connector?

1557

---

What is staging variable?

1029

---