Answer Posted / sridhar

Persistent cache: U can save the lookup cache files and
reuse them the next time the informatica server processes a
lookup transformation configured to use the cache.

Recache from database: If the persistent cache is not
synchronized with he lookup table,U can configure the lookup
transformation to rebuild the lookup cache.

Static cache: U can configure a static or readonly cache for
only lookup table.By default informatica server creates a
static cache.It caches the lookup table and lookup values in
the cache for each row that comes into the
transformation.when the lookup condition is true,the
informatica server does not update the cache while it
prosesses the lookup transformation.

Dynamic cache: If u want to cache the target table and
insert new rows into cache and the target,u can create a
look up transformation to use dynamic cache.The informatica
server dynamically inerts data to the target table.

shared cache: U can share the lookup cache between multiple
transactions.U can share unnamed cache between
transformations inthe same maping.

What are the popular informatica products?

1013

---

What are the issues you have faced in your project? How did you overcome those issues?

2365

---

Define enterprise data warehousing?

1205

---

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

1171

---

What is domain and gateway node?

1165

---

Implementation methodology

1714

---

difference between informatica 8.1.1 and 8.6

3677

---

Explain about Informatica server process that how it works relates to mapping variables?

1079

---

When do you use sql override in a lookup transformation?

1099

---

Can we create multiple integration service on single repository?

1187

---

Explain the different kinds of facts.

981

---

what is size of u r database?

2311

---

What is workflow manager?

1049

---

While importing the relational source definition from the database, what are the metadata of source that will be imported?

1269

---

What is flashback table ? Advance thanks

1942

---