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,

---

What are the reusable transformations?

0 Answers   Informatica,

---

Why we use stored procedure transformation?

4 Answers  

---

what are the limitation of sorter transformation?

2 Answers   TCS,

---

I have some rows in source.I have to map half rows to one target and half rows to another target.i.e you wont know how many records in source.?Implement a mapping?

1 Answers   Franklin Templeton,

---

Tell me about Propagate functions in informatica

0 Answers  

---

If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?

2 Answers  

---

Why do we need informatica?

0 Answers  

---

Tell me how many tables used in Ur project and how many fact tables and dimension tables used in ur project

2 Answers   iGate, Qualcomm,

---

What is dimensional table? Explain the different dimensions.

0 Answers  

---

what is incremental loading ?

12 Answers   CTS, IBM, Oracle, TCS,

---

Explain the etl program with few examples.

0 Answers  

---