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
- 27616 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
how many types of dimensions are available in informatica?
Explain how to import oracle sequence into informatica?
Explain dynamic target flat file name generation in informatica
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What do you mean by filter transformation?
my source is junk data how will u remove that junk data by using unix please any one replay me
What is pmcmd command?
What is dimensional table? Explain the different dimensions.
What is rank transform?
expain about the tune parameters?
Define mapplet?
What the difference is between a database, a data warehouse and a data mart?
How to configure mapping in informatica?
What does role playing dimension mean?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
