how u know when to use a static cache and dynamic cache in
lookup transformation.
Answer Posted / nitin
I have a major doubt in static and dynamic cache.
1. what is the use of both?
2. while using dynamic cache(looking up target table),say a record is entering from source emp_id = 101, which is already in the target so this will be updated am i correct?
3. while using a static cache, same scenario as above the record also gets updated.
4. what happens in both the caches, when again a same record enters from the source
5. when will the record be rejected as a duplicate?
from my understanding, while using a static cache for already existing record in target. when a same record appears twice from source then the record that is appearing second time will be rejected as a duplicate. but in dyanmic cache it will not?.. is this true?
Please help me understand when the record will be rejected as a duplicate and when it will be updated, in case of dynamic and static cache
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is Session and Batches?
Can we create multiple integration service on single repository?
How to create the source and target database connections in server manager?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
Describe an informatica powercenter?
What is a repository? And how to add it in an informatica client?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
wat are deployement groups in informatica, how it will be used for developers
How to update or delete the rows in a target, which do not have key fields?
write a query to retrieve the latest records from the table sorted by version(scd)
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What is informatica metadata and where is it stored?
define galaxy repository in informatica
Explain lookup transformation source types in informatica
Enlist the differences between database and data warehouse.