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.

How does a sorter cache works?

1000

---

what is the complex transformation you used in informatica

2524

---

What is status code in informatica?

959

---

What are the components of the workflow manager?

1078

---

What is a code page?

1115

---

What is the fact table?

993

---

What is the cumulative sum and moving sum?

1135

---

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

7314

---

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2139

---

Global and Local shortcuts. Advantages.

1957

---

Enlist the advantages of informatica.

1005

---

What are the different types of repositories created using informatica?

1059

---

Explain the different dimensions.

913

---

Design a mapping to load a target table with the following values from the above source?

1284

---

How identifying bottlenecks in various components of informatica and resolving them?

1055

---