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

How do you manage the Parameter files while migrating your data from one environment to another environment?

523


Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

571


What is target designer and target load order?

635


What are the basic requirements to join two sources in a source qualifier transformation using default join?

589


without table how to come first record only in oracle?

1830






How to extract sap data using informatica?

581


difference between repository database and repository service?

595


What is the function of aggregator transformation?

553


Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

604


can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10251


How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

687


What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

533


Differentiate between router and filter transformation?

591


Why filter transformation is an active one?

541


Explain what are the different types of transformation available in informatica.

534