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
- 27287 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 sorter transformation?
where to store informatica rejected data? How to extract the informatica rejected data?
what is song in infrmatica...?
Write the unconnected lookup syntax and how to return more than one column.
Write the program through which the records can be updated?
What is a predefined event?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What is a passive transformation?
What are the performance considerations when working with aggregator transformation?
According to his methodology what all you need before you build a datawarehouse
What are the tasks that source qualifier perform?
Explain how many types of dimensions are available in informatica?
Enlist some properties of sessions.
What does “tail –f” command do and what is its use as an Informatica admin.
What are the differences between joiner transformation and source qualifier transformation?
