Difference between static cache and dynamic cache

Static cache	Dynamic cache
U can not insert or update the cache	U can insert rows into the cache as u pass to the target
The informatic server returns a value from the lookup table or cache when the condition is true.When the condition is not true, informatica server returns the default value for connected transformations and null for unconnected transformations.	The informatic server inserts rows into cache when the condition is false.This indicates that the the row is not in the cache or target table. U can pass these rows to the target table

Interview Candidate
Sep 21st, 2004
1
14027

Informatica

Answer

Showing Answers 1 - 1 of 1 Answers

vp

Mar 6th, 2006

lets say for example your lookup table is your target table. So when you create the Lookup selecting the dynamic cache what It does is it will lookup values and if there is no match it will insert the row in both the target and the lookup cache (hence the word dynamic cache it builds up as you go along), or if there is a match it will update the row in the target. On the other hand Static caches dont get updated when you do a lookup.