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 do you mean by enterprise data warehousing?
Explian the Process of deployment groups in informatica
Define sessions in informatica etl?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What are the informatica performance improvement tips
What are the types of schemas we have in data warehouse and what are the difference between them?
What is the surrogate key?
Can we create a node as a gateway node and the same node can be assigned to a grid?
How can we create index after completion of load process?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
write a query to retrieve the latest records from the table sorted by version(scd)
How to configure mapping in informatica?
Explain Dataware house architecture .how data flow from intial to end?
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?
What is the way to execute pl/sql script using informatica mapping?