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
When do you use sql override in a lookup transformation?
Differentiate between reusable transformation and mapplet.
What is the session task and command task?
What is the reusable transformation?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
How to generate or load values in to the target table based on a column value using informatica etl tool.
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
How many transformations can be used in mapplets.
Explain constraint based loading in informatica
Explain incremental aggregation in informatica
What is union transformation in informatica?
Which version configuration tool used in ur project?
What is the difference between writing a joiner query in ANSI style and THETA style?
What is data transformation manager process?
What are the differences between oltp and olap?