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
What is a joiner transformation?
Explain the features of connected and unconnected lookup.
How you know when to use a static cache and dynamic cache in lookup transformation?
What are active and passive transformations?
my source is junk data how will u remove that junk data by using unix please any one replay me
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
How to update source definition?
How to create a non-reusable instance of reusable transformations?
What are the databases that informatica can connect to windows?
How to elaborate powercenter integration service?
How to load the data from a flat file into the target where the source flat file name changes daily?
What is informatica metadata and where is it stored?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
explain one complex mapping with logic? sales project?
COM components can be used in Informatica
