Informatica: Types of Caches

static cache

is one in which data when changed in the target table cannot be incorporated in
the look up while the session is running.

when you use a dynamic cache any changes to the target table gets reflected in the lookup
even if the record is being inserted or updated in the same mapping run priorly