1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

what is persistant cache in which situation we will use
persistantcache

Question Posted / sunil.knl


what is persistant cache in which situation we will use persistantcache..

Answer / reddy

parcistance cache is one of the cache which is in lookp t/r
It is used in multiple session runs.this improves the
performance.
If we wnat to run the same session more then one time then
we go for percistance cache.

Is This Answer Correct ?    5 Yes 3 No

Post New Answer

More Informatica Interview Questions

we have tables like c1 a c2 b c3 c c4 x c5 y and i need output like abcx in a single row and abcy in a single row? how do u do this?

2 Answers   Patni, Tech Mahindra,

Do you have knowledge in ralph kimball methodology

1 Answers  

What is the query to find nth highest salary? What is the use of cursors?

8 Answers   Keane India Ltd,

how the server recognises , if the session fails after loading the 100 records in to the target

2 Answers   TCS,

IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT WILL TAKE ONLY THE LAST COLUMN WHY????

3 Answers   IBM,




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

1 Answers  

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

0 Answers   HCL,

i have 1000 record flat file source i want 1st row to 1st target, 2nd row to 2nd target, 3rd row to 3rd target how will u do? Without using Mod Function? Explain....

4 Answers   TCS,

write sql query to remove null value following table id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output id name 101 dinesh 102 suresh 103 prakesh

5 Answers   Accenture,

yesterday my session run ten min.today its run 30min, wt is the reason? if any issues how to solve that?

2 Answers   iGate,

i have two coloumn emp_no sal 1 3000 2 3000 3 3000 4 4000 5 5000 6 2700 7 4500 i just need output by removing duplicate.my answer should be emp_no sal 1 3000 2 4000 3 5000 and so on.please tel me the transformation to use and if variable is used in expression then how can i give variable expression

3 Answers  

How can we integrate different flat file data in a single mapping and with in a single execution

1 Answers  

For more Informatica Interview Questions Click Here
Categories