what is persistent lookup cahce?how to use and when to use
this persistent lookup cahce?explain?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

What is a repository manager?

0 Answers  


for ex: in source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target. what will happen.

11 Answers   Accenture,


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,


Can we create a Integration service without a Repository service and vice versa?

0 Answers  


Hi,tell me the system testing and Integration Testing in the Informatica ? Thank You

2 Answers   TCS,






i did MBA in 2008. i got job as a Software Engineer(Informatica) in 2008 February in our college campus interviews through consultancy. my problem is when iam going interview HR people ask " YOu are MBA graduate how u get software(informatica) job". iam saying i got job in campus interviews. i have knowledge in informatica in dataware housing. is this answer correct or not. plese give me guidence

1 Answers   IBM,


difference between top down(w.h inmon)and bottom up(ralph kimball)approach?

2 Answers   PayPal,


i have two sources two flatfiles same structure one flatfile contain 100 million recs another flatfile contain 10 million recs i have to connect single target(performance oriented answer) what are the steps we have to do this scenario

4 Answers   Polaris,


how can u tune u r informatica mapppings

2 Answers   CTS,


What is operational data source (ODS)?

7 Answers  


5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

0 Answers  


If a session fails after loading of 10,000 records in to the target.How can you load the records from 10001?

5 Answers   TCS,


Categories