Interested to Buy Any Domain ? << Click Here >> for more details...
how u know when to use a static cache and dynamic cache in
lookup transformation.
- 9 Answers
- 27226 Views
- Accenture, I also Faced
- E-Mail Answers
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 incremental aggregation?
What are the types of lookup transformation?
What are the components of the workflow manager?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Which version configuration tool used in ur project?
what is the difference between informatica6.1 and infomatica7.1
What is the sequence generator transformation in informatica?
What is a node in Informatica?
How can we store previous session logs?
how many types of dimensions are available in informatica?
Explain what are the different versions of informatica?
How do you take back up of repository?
Briefly define a session task?
What is a surrogate key?
4 yrs etl devloper roles and responsibilities?any body give solutions
