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.....
Dynamic lookup can be used in loading SCD, by placing it just before the target table
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.
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!