Answer Posted / harish konda
The Dynamic Lookup Cache is used to update/insert the data
into the cache.
When the session starts, if dynamic cache is used, it
fetches all the target data into its cache. And during the
session IS scans the whole dynamic cache acc. to the lookup
condition we give. It updates/inserts the cache accordingly
if the row exists/new row respectively.
When dynamic cache is selected one column named
"NewLooupRow" gets added into the lookup t/f. When a row
coming from source is new then returns 1 that is insert,
when a row coming as update then its returns 2 that is
update, and when a row coming with no changes as it is in
target before then 0 is returned.
So we can use these NewLooupRow values in other t/f's
accordingly and give conditions to update/insert/reject.
So indirectly target table gets updated/inserted/deleted
according to these values of NewLooupRow only.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is main use of mapplet?
Tell me about MD5 functions in informatica
What are the different options available for update strategy?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What is the difference between router and filter?
How to extract sap data using informatica? What is abap? What are idocs?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
How many ways are there to create ports?
How many ways a relational source definition can be updated and what are they?
What is informatica worklet?
What is data caches/ index caches?
What is lookup change?
What you know about transaction control transformation?
what are the Methods For Creating Reusable Transformations?
State the differences between sql override and lookup override?
