Interested to Buy Any Domain ? << Click Here >> for more details...
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
Enlist the advantages of informatica.
What is target load order?
What is workflow manager?
What does update strategy mean, and what are the different option of it?
what is informatica metadata?
Performance tuning in UNIX for informatica mappings?
What is rank index in rank transformation?
What is a grid in Informatica?
What is mapplet in informatica?
Can we change Dynamic to Static or Persistent cache? If so what happens?
What is the benefit of partitioning a session?
How can we use mapping variables in informatica?
What are the designer tools for creating transformations?
What is status code in informatica?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
