suppose we are using dynamic lookup cache and in lookup
condition the record is succeeded but in target it is failed
due to some reasons then what happened in the cache ?
Answer Posted / santosh kumar sarangi
Hi Urs, as you told, if record exit then it will update so
can you please clarify which one it will update cache or
target table. If it will update the target table the why we
need the update strategy T/R.
In my view, if any things updating in the dynamic look up
cache then it's responsibility of developer to update the
same in the target, other wise look up cache and target will
not be in sync,
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is source qualifier transformation in informatica?
Separate from an archive server and a powerhouse?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What is the surrogate key?
What is primary and backup node?
What is informatica metadata and where is it stored?
Explain the use of aggregator cache file?
lookup transformation with screenshots
How can informatica be used for an organization?
Explain what are the different types of transformation available in informatica.
Explain the mapping variable usage example in informatica
Do you find any difficulty while working with flat files as source and target?
4 yrs etl devloper roles and responsibilities?any body give solutions
What are the types of lookup 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