uncached, static cache and dynamic cache

Difference between uncached, static cache and dynamic cache

                                                                    

Uncached	Static Cache	Dynamic Cache
You cannot insert or update the cache.	You cannot insert or update the cache.	You can insert or update rows in the cache as you pass rows to the target.
You cannot use a flat file lookup.	You can use a relational or a flat file lookup.	You can use a relational lookup only.
When the condition is true, the PowerCenter Server returns a value from the lookup table or cache. When the condition is not true, the PowerCenter Server returns the default value for connected transformations and NULL for unconnected transformations.	When the condition is true, the PowerCenter Server returns a value from the lookup table or cache. When the condition is not true, the PowerCenter Server returns the default value for connected transformations and NULL for unconnected transformations.	When the condition is true, the PowerCenter Server either updates rows in the cache or leaves the cache unchanged, depending on the row type. This indicates that the row is in the cache and target table. You can pass updated rows to the target table. When the condition is not true, the PowerCenter Server either inserts rows into the cache or leaves the cache unchanged, depending on the row type. This indicates that the row is not in the cache or target table. You can pass inserted rows to the target table.