Answer Posted / ankur saini er.ankur861@gmail.

we use dynamic lookups in case we have duplicates in source
and source says that they cnt remove them as per
requirement ...in that case we have to settle for:
say we have a reocrd id=1 , name=a
id=1 , name=b
so depending upon the PI id this is a duplicate so using
dynamic lookup when firts record comes the lookup cache
will have id=1 , name=a
again will duplkicate row will come then it gets updated to
id=1 , name=b
so finally only last record from the quplicates will be
lloaded in the target

What is a passive transformation?

1054

---

How can we use mapping variables in informatica?

1023

---

What are the components of the workflow manager?

1098

---

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1532

---

What can we do to improve the performance of informatica aggregator transformation?

1061

---

Have you worked with/created Parameter file

1635

---

Tell me about MD5 functions in informatica

891

---

What does cheating measurement mean?

1010

---

What is option by which we can run all the sessions in a batch simultaneously?

1095

---

How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

1599

---

How to load a Dimension ? and how to load a fact table?

1390

---

How to extract the informatica rejected data?

1181

---

What are the restrictions of union transformation?

997

---

How do you load only null records into target? Explain through mapping flow.

1976

---

How does a rank transform differ from aggregator transform functions max and min?

1167

---