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 are the conditions needed to improve the performance of informatica aggregator transformation?
How you know when to use a static cache and dynamic cache in lookup transformation?
What happens when a session fails and you click on recover?
Explain scd type 3 through mapping.
How can you differentiate between powercenter and power map?
Suppose we do not group by on any ports of the aggregator what will be the output?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What will be the approach?
What are mapplets? How is it different from a Reusable Transformation?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What are the different types of transformation available in informatica.
What are the new features of informatica 9.x at the developer level?
In development project what is the process to follow for an etl developer from day1