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
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks
What does update strategy mean, and what are the different option of it?
How are indexes created after completing the load process?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Explain the different kinds of facts.
What do you understand by term role-playing dimension?
What is a rank transform?
Explain load alternative records / rows into multiple targets - informatica
what is diff b/t sorter t/r and agg have the option sorter property...
What is Cognos script editor?
Explain in detail about scd type 1 through mapping.
Why do you use Mapping Parameter and mapping variable?
What are the advantages of using informatica as an etl tool over teradata?
Why filter transformation is an active one?
How do you load only null records into target?
