in performance wise union is past,union all is past

2 Answers  

---

Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?

2 Answers  

---

What is the difference between router and filter?

0 Answers  

---

What is the use of incremental aggregation?

2 Answers  

---

What is the scenario which compels informatica server to reject files?

0 Answers  

---

---

Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

0 Answers  

---

which quality process u can approach in ur project

1 Answers   CTS,

---

write a query for how to eliminate the duplicate rows without using distinct?

6 Answers   iGate,

---

i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))

5 Answers   Cap Gemini,

---

hi guys..iam a QA person ..what is ETL TESTING... what is the process of ETL testing... ETLTESTER needs etl devolopment knowledge or not? pls suggest ur valuable decision

2 Answers  

---

what is mapping parameter?

2 Answers   Cap Gemini,

---

Suppose we are using a Dynamic Lookup in a Mapping and the commit Interval set for the tgt is 10000. Then how does the data get committed in the lookup if there were only 100 roows read from the src and the dynamic lookup dint have the 100th row in it?

3 Answers   Deloitte, TCS,

---