Please explain me when a dynamic look up cache is updated in informatica? Is it updated at the end or for each row?
Source row is compared against with the look up cache. If the source does not exist in the cache, then the row will be inserted into the cache. If the row exisits and there are any changes, then the row is updated in the cache. If the row exists and there are no changes, then nothing will happen in the cache.
Cache is not udpated at the end. It is updated during the session run.