Answer Posted / mohanreddybank
There are different caches we have in informatica
Static, dynamic,persistent,shared lookup cache
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
what is the complex transformation you used in informatica
What the difference is between a database, a data warehouse and a data mart?
How to create a non-reusable instance of reusable transformations?
Make a note of the quantity vaults made in informatica?
What is meant by lookup transformation?
Explain the pipeline partition with real time example?
How do you remove duplicate records in informatica? And how many ways are there to do it?
Clarify the aggregator change?
What is a joiner transformation?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
How to load the data from a flat file into the target where the source flat file name changes daily?
When do you use sql override in a lookup transformation?
What are the types of presistent cache in look up tr.
Explain sessions. Explain how batches are used to combine executions?
Target increases every day even though no new record was inserted