Answer Posted / harish konda

Dynamic cache is used to update/insert the records into the
cache during the session run. From there we can
update/target table with the NewLookupRow values returned by
lookup.

If you want to use the same lookup cache in other mappings
also then we will go for Persistent Cache.

The difference is for eg, in the first mapping when we use
dynamic cache, when the session ends, the cache gets deleted
automatically. So to use this cache in other mappings also
check give one option "Persistent Cache".

So when we use this option, the cache in the memory gets
Saved even after session ends. From there we can use that in
other mappings.

What is the use of transformation?

1051

---

How to generate sequence numbers without using the sequence generator transformation?

1252

---

What are the components of Informatica? And what is the purpose of each?

1108

---

Explain scd type 3 through mapping.

1050

---

How do you promote a non-reusable transformation to reusable transformation?

1179

---

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

2050

---

What is the difference between informatics 7x and 8x and what is latest version?

1135

---

In which transformation you cannot drag ports into it?

1374

---

What is a repository manager?

1143

---

Slowly changing dimensions, types and where will you use them

1767

---

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

1184

---

What is a difference between complete, stop and abort?

1123

---

Explain sessions. Explain how batches are used to combine executions?

1075

---

Explain sessions and how many types of sessions are there?

1053

---

what is the size ur source like(file system or database)? how many record daily come u r banking project?

2189

---