Answer Posted / krishna

hi neetu,
i hope you were a bit wrong.
static cache is also used to check whether row exists or
not.....
well krishna for your question on dynamic cache..
static cache is one in which data when changed in the
target table cannot be incorporated in the look up on the
fly.
when you use a dynamic cache any changes to the target
table gets reflected in the lookup even if the record is
being inserted or updated in the same mapping run priorly

What is flashback table ? Advance thanks

1869

---

What is expression transformation?

1032

---

Why is sorter an active transformation?

1058

---

Difference between Target-based loading and constraint-based loading?

943

---

What is a pre-defined event and user-defined event?

970

---

What is the sql query overwrite in source qualifier in informatica

1023

---

What does role playing dimension mean?

996

---

What is the surrogate key?

1143

---

What is a filter transformation?

986

---

What is aggregator transformation in informatica?

895

---

What are multi-group transformations?

1007

---

How you can differentiate between connected lookup and unconnected lookup?

1003

---

Explain Dataware house architecture .how data flow from intial to end?

2524

---

What is rank index in rank transformation?

1010

---

What are session parameters ? How do you set them?

1772

---