Answer / ramu

persistent cache is used when u r mapping contains multiple dimensions table, which is used in several times. if you use persistence cache all the index files and data files are stored in memory. when the integration serviece second time calls the same lookup table it wioll fetch the data from the memory cache files instead of re-creating the index and data cache files. we can use the same cache by using one name prefix of the lookup properties.
to use use persistence cache we can divide them in to two types.
1) names persistence cache
2) un named persistence cache.

1) named persistence cache: we can use the same persistence cache between several mappings.
2)un named persistence cache we can use the same cache with in the mapping only.

lookup is passive y can't it be active? let us say i have some records in my source like 101,rohit,1000 101,rohit,1000 102,kumar,2000 like wise now as it is having multiple matches i return only first,last value it can't return bouth the values that means lookup is acting as select distinct right by default what means it is active?

5 Answers   IBM,

---

Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@ayhoo.co.in

2 Answers  

---

Write the unconnected lookup syntax and how to return more than one column.

0 Answers  

---

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

0 Answers   HP,

---

What is the surrogate key?

0 Answers  

---

what is system requirement(SR) & business requirement(BR)?

2 Answers   Ness Technologies,

---

Define error Threshold?

1 Answers  

---

In Flat file Input is A B C I need output like this A A A B B B C C C. How will u achieve this?

5 Answers   iNautix,

---

how to import multiple flat files in to single target where there is no common column in the flat files

2 Answers   TCS,

---

with out using update strategy transnsformation how to update the data in mapping level

1 Answers  

---

Tell me one complex query in oracle ?

2 Answers   L&T, Satyam,

---

What is union transformation in informatica?

0 Answers  

---