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
- 27553 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 is an active transformation?
Define joiner transformation?
Explain pushdown optimization and types in informatica
Name at least 5 different types of transformations used in mapping design and state the use of each.?
Why do you use Mapping Parameter and mapping variable?
Explain dynamic target flat file name generation in informatica
define galaxy repository in informatica
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
Explain the shared cache and re-cache?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Explain transaction control transformation in informatica
How we can use union transformation?
What is blocking transformation?
What are the different ways to implement parallel processing in informatica?
To import the flat file definition into the designer where should the flat file be placed?
