what is the diff b/w cached and unchaed look ups
Answer Posted / sujana
if v cache the lukup..IS queries the cache for each row dat
eneters
if v dont cache IS queries the database for each row dat
enters..i.e issues a slect statemnt for each row
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What are the steps involved in the migration from older version to newer version of Informatica Server?
Is it possible to create multiple domains on a single Informatica server?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What is an Integration service in Informatica?
Have you worked with/created Parameter file
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What is informatica powercenter repository?
what is the Default Source Option For Update Strategy Transformation?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What are the mapping parameters and mapping variables?
What is a dimensional model?
What are the advantages of informatica?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
Explain the use of aggregator cache file?
What is an unconnected transformation?