Answer Posted / swetha

Persistent cache: yoU 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, yoU 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 you want to cache the target table and
insert new rows into cache and the target, you can create a
look up transformation to use dynamic cache.The informatica
server dynamically inerts data to the target table.

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

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

1573

---

What is the difference between a repository server and a powerhouse?

1409

---

What do you understand by a term domain?

1060

---

What is a standalone command task?

1132

---

What is dimensional table?

1001

---

Which is the t/r that builts only single cache memory?

1123

---

EXL informatica Questions

1309

---

What is workflow monitor?

993

---

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

1994

---

What is meant by a domain?

1077

---

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

2055

---

What is an unconnected transformation?

1032

---

What do you mean by channel change?

964

---

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2506

---

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

2092

---