Home > Software > Data-Warehouse > Informatica
Interview Questions   Tutorials   Discussions   Programs   

Informatica - What is Dynamic lookup Transformation? when we use?

asked marvit April 10, 2015 04:41 AM  

What is Dynamic lookup Transformation? when we use?


4 Answers

answered By Beginner   0  
This answer is pending moderator approval Dynamic lookup is mainly used to SCD type mappings, when we want to update cache before we load data to target table so that data in cache always remains consistent with target table data.It is mainly used to remove duplicates as lookup checks updates with every record, so duplicates gets removed which we cant do with statis cache.So, mainly if u want to update lookup table along with target table rather than updating after successful session run or u want to remove duplicates u can use dynamic lookup cache.
   add comment

answered By Shivam   0  
Dynamic Lookup, will be performing Update operation.. This is not first operation. This will be supported by Connected Lookup only.
   add comment

answered By Kalisetty   0  

Dynamic lookup updates cache before writes data into the target...first it will update cache then only it updates target table...generally we are using it in SCD's.....

   add comment

answered By Anuj   0  

Dynamic lookup can be used in loading SCD, by placing it just before the target table

   add comment

answered By Mswami   0  

Dynamic Lookups are used for implementing Slowly Changing dimensions. The ability to provide dynamic caching gives Informatica a definetive edge over other vendor products. In a Dynamic Lookup, everytime a new record is found (based on the lookup condition) the Lookup Cache is appended with that record. It can also update existing records in the cache with the incoming values.

   add comment

Your answer

Join with account you already have



Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!