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.

What is a node in Informatica?

1042

---

What are the tasks that can be performed using sq?

1093

---

What is the session task and command task?

1060

---

Describe expression transformation?

1126

---

Explain lookup transformation is active in informatica

1106

---

What is meant by LDAP users?

1209

---

Define sessions in informatica etl?

1035

---

What is a router transformation?

1130

---

what is $$$$?

2160

---

What are the different lookup cache(s)?

1118

---

What is the use of code page?

1096

---

Explain dynamic target flat file name generation in informatica

1055

---

Explain what are the different types of transformation available in informatica.

1150

---

What are the modules in Power Center

1680

---

is it possible to index the data in cache of lkp transformation ?

2029

---