Informatica dynamic lookup cache not updating dating russia and ua
And if lookup condition is not satisfied then it returns either NULL or default value.
If the lookup condition is matching it returns the value from Lookup table or cache .Once a Cache is created the Integration Service always queries the Cache instead of the Lookup Table. Integration service creates Static Cache by default while creating lookup cache.In Static Cache the Integration Service does not update the cache while it processes the transformation. In Dynamic Cache we can insert or update rows in the cache when we pass the rows.Meaning, if a customer changes his address, the old address is updated with the new address.But your data warehouse table stores the history (may be in the form of SCD Type-II).