how u know when to use a static cache and dynamic cache in
lookup transformation.
Answer Posted / neetu arora
Dynamic cache is generally used when u are applying lookup
on a target table and in one flow same data is coming twice
for insertion or once for insertion and once for updation.
Performance: dynamic cache decreases the performance in
comparision to static cache since it first looks in the
whole table tht whether data ws previously present if no
thn only it inserts so it takes much tym
Static cache do not see such things just insert data as
many tyms as it is coming.
Is This Answer Correct ? | 21 Yes | 1 No |
Post New Answer View All Answers
What is the function of union transformation?
Explain the use of aggregator cache file?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Enlist the tasks for which source qualifier transformation is used.
What is the function of aggregator transformation?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What are the advantages of informatica?
What is InformaticaPowerCenter?
What is a repository? And how to add it in an informatica client?
What is the cumulative sum and moving sum?
What is a stored procedure transformation?
How can we remove the duplicates from flat file source?
what is unit testing?tell me proceedure
tell me the rules and responsblites in our project(my project is development)