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.

If there are more than one sessions running parallel in a worklet, which will be the last session ?

2 Answers  

---

Hi All, I have three question. 1) How to remove the header and footer in a flat file in informatica? 2)How to load the first and last record of flat file into the target? 3)I have a Input and Output table. Input Name Salaray Month A 100 Jan A 200 Feb A 300 March B 400 April B 500 May B 600 June Output Name Salaray Month A 100 Jan A 300 Feb A 600 March B 400 April B 900 May B 1500 June How to implement and get the ouput as mentioned above. If Possible kindly provide the SQL query also. Kindly any one help to implement this concept. Thanks, Pradeep

3 Answers   CSC, iNautix,

---

Informatica software installation 8.1/7.1.3/7.1 with oracle 10g database (optional Teradata v2R6)

1 Answers  

---

what is the difference between mapplet & stored procedure?

1 Answers  

---

How can we get multiple output values using an unconnected lookup transformation?

2 Answers   TCS,

---

---

What is a configuration management?

1 Answers  

---

what is the method of error handling when session is running?

1 Answers   TCS,

---

What is a predefined event?

0 Answers  

---

Which is better performance wise database or file?How?

2 Answers   TCS,

---

if i have 10 records in my source,if we use router t/r and given the condition as i>2,i=5 and i<2in the different groups what is the o/p in the target

5 Answers   TCS,

---

tell me the rules and responsblites in our project(my project is development)

0 Answers  

---

What is the benefit of partitioning a session?

0 Answers  

---