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

In which situation we will use persistant cache and shared
cache in real time. plzsss answer with example

Question Posted / baladevshree


In which situation we will use persistant cache and shared cache in real time. plzsss answer with e..

Answer / nitish kumar

Persistant cache we use when our data or lookup values are not changing frequently so as we know Persistant cache will be saved in cache folder so it can be reused in next session run. Because of this reusability this will basically reduce the run time of workflow.

Also since in persistant cache we have a copy of cache file we can share the same cache to other session if it required.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

without using emailtask how will send a mail from informatica?

3 Answers  

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

0 Answers   Cap Gemini,

wt is Dynamic lookup Transformation? when we use?how we use?

2 Answers   TCS,

error reading data in flatfiles. Instead rading Ravi Teja its reading Ravi?Teja.How to handle this issue.

4 Answers  

When will you use SQL override in a lookup transformation?

1 Answers  




I have source like this year account month amount ----- --------- ------ -------- 1999 salaries jan 9600 1999 salaries feb 2000 1999 salaries mar 2500 2001 benfits jan 3000 2001 benfits feb 3500 2001 benfits mar 4000 -->i need target like this year account month1 month2 month3 ----- --------- -------- -------- -------- 1999 salaries 9600 2000 2500 2001 benfits 3000 3500 4000

4 Answers   HCL,

source table have single column single record having with single space. load that source record into trg . trgt having two columns and the SOURCE TABLE LIKE COL1 BHANU PRASAD TRGT TABLE COL1 COL2 IN THAT LOAD THE RECORD IN THE trgt table LIKE COL1 COL2 BHANU PRASAD HOW ? TELL ME PLZ

2 Answers   Wipro,

what we require for D.modelling?

1 Answers  

What are the reusable transforamtions?

1 Answers  

can we send mail when ever it get success or faulure to other mailid?(Not company mail id)

1 Answers   Puma,

What exactly mentioned in High level design document.can somebody explain me sequentialy.

1 Answers   IBM,

If I have router with 10 records, if the condition doesn’t satisfy the records will pass to the default group,then where can we see that records and where that records will store?

4 Answers  

For more Informatica Interview Questions Click Here
Categories