Static Cache Dynamic Cache
A static cache is a default cache, and we cannot insert or update the caches In the dynamic cache, we can insert or update data into the lookup and pass the data to the target.
Handles multiple matches Doesn't handles multiple matches
Suitable for relational and flat file lookup types Suitable for relational lookup types
Relational operators like = &= can be used Only = operator is used
Used for both connected and unconnected lookup transformation Used for only connected lookup transformation
