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 do you mean by enterprise data warehousing?

829


Explian the Process of deployment groups in informatica

827


Define sessions in informatica etl?

793


Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2109


What are the informatica performance improvement tips

831


What are the types of schemas we have in data warehouse and what are the difference between them?

731


What is the surrogate key?

858


Can we create a node as a gateway node and the same node can be assigned to a grid?

850


How can we create index after completion of load process?

831


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

902


write a query to retrieve the latest records from the table sorted by version(scd)

853


How to configure mapping in informatica?

909


Explain Dataware house architecture .how data flow from intial to end?

2340


Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

1435


What is the way to execute pl/sql script using informatica mapping?

1252