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.

In session log thier should not be a single error how will u do

3 Answers   HCL,

---

list out all the transformations which use cache?

0 Answers   Informatica,

---

can we have to do changes in session property when we are dynamically generating target files?

3 Answers   Wipro,

---

what is meant by data driven.. in which scenario we use that..?

2 Answers   IBM,

---

Hi all,Can any one provide me Informatica Designer Certification dumps.I need all three papers dumps.If any one has these dumps then plz send it on this id:- nagesh.jujjuru@yahoo.com Thanks in advance

1 Answers  

---

Explain in detail about scd type 1 through mapping.

0 Answers  

---

what is flat file override?

1 Answers   Cap Gemini, HP,

---

What is critical mapping?

2 Answers  

---

How to Create a folder using pmrep command?

0 Answers  

---

i have one senario i have table with 2columns one for primary key another is a constant value(zero). i have to lookup the table and get the maximum primary key here i don't have any common column between source and lookup table(wt table i explained above)... table is (i am assuming he didn't give the table) column1 column2 5 0 2 0 8 0 6 0 3 0 12 0 7 0

2 Answers   TCS,

---

How to convert IBM Cognos generated XML to a readable XML format for ETL tools

1 Answers  

---

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

0 Answers   Puma,

---