Answer / veni

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.

Answer / srikanth

A cache is a memory area where informatica server holds the
data to perform calculations during the session. It
creates cache files in the $PMcachedir and as soon as the
session finishes, server deletes the cache files from the
directory.

if we know the data does not change between session runs,
we can persist on the disk (persistent cache ) and use
those files in other sessions. in this case, the server
does not delete the cache files as soon as the session
finishes.

what we require for D.modelling?

1 Answers  

---

What is InformaticaPowerCenter?

0 Answers   Informatica,

---

What is difference between a gateway node and worker node?

0 Answers  

---

i did MBA in 2008. i got job as a Software Engineer(Informatica) in 2008 February in our college campus interviews through consultancy. my problem is when iam going interview HR people ask " YOu are MBA graduate how u get software(informatica) job". iam saying i got job in campus interviews. i have knowledge in informatica in dataware housing. is this answer correct or not. plese give me guidence

1 Answers   IBM,

---

What is joiner change?

0 Answers  

---

Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR IN ORACLE & INFORMATICA LEVEL HOW TO ACHIVE

2 Answers   Wipro,

---

I am getting five sources in a day and i donot know when i get them. i need to load data into the target and run the session. but here i can't keep the session in running or can't stop the session. plz help me

6 Answers   Mastek,

---

source : col1 101 101 101 102 102 102 103 103 103 col2 1000 1500 2000 1200 2300 3000 2400 1300 2000 i need target as col1 101 102 103 col2 1000,1500,2000 1200,2300,3000 2400 1300 2000

6 Answers   CTS, Wipro,

---

Explain informatica architecture - version 8 / 9

0 Answers   Informatica,

---

how many new transformations are introduced in 8.1 which are not available in 7.1? any new transformation in 8.6?

2 Answers   emc2,

---

What are the new features of the server manager in the informatica 5.0?

1 Answers  

---

i want excute multiple sessions in one workflow using the "start task".what do i need to do?

2 Answers  

---