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


Please Help Members By Posting Answers For Below Questions

What is the function of union transformation?

865


Explain the use of aggregator cache file?

950


Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

827


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?

795


Enlist the tasks for which source qualifier transformation is used.

797


What is the function of aggregator transformation?

833


Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2100


What are the advantages of informatica?

778


What is InformaticaPowerCenter?

917


What is a repository? And how to add it in an informatica client?

923


What is the cumulative sum and moving sum?

983


What is a stored procedure transformation?

822


How can we remove the duplicates from flat file source?

808


what is unit testing?tell me proceedure

2005


tell me the rules and responsblites in our project(my project is development)

1738