what is the advantage of persistent cache? when it should be
used?
Answer Posted / kvikas2056
If you are using multiple look up transformations on same table, at that time you can use persistent named cache.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how do u implement configuration management in Informatica?
What is fact? What are the types of facts?
What are the names of the layers in etl?
diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
where is the cache (lookup, index) created and how can you see it.
when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?
what make u disappointmnets in u r career
what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?
Explain about round-robi?
What are three tier systems in etl?
what is the main role of FI on business
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.
what is the use of structures?how many nodes can u create in a structure?
What is a lookup table in etl?