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
How do you manage the Parameter files while migrating your data from one environment to another environment?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What is target designer and target load order?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
without table how to come first record only in oracle?
How to extract sap data using informatica?
difference between repository database and repository service?
What is the function of aggregator transformation?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
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?
Differentiate between router and filter transformation?
Why filter transformation is an active one?
Explain what are the different types of transformation available in informatica.