| Caches of this type are GENERATED once and re-used throughout a session. | During the session, data is continuously inserted/updated into the dynamic cache. |
| As our static cache cannot be inserted or updated during the session, it remains unchanged. | The dynamic cache changes as we can add or update data into the LOOKUP, then pass it on to the target. |
| Multiple matches can be handled in a static cache. | Multiple matches can't be handled in the dynamic cache. |
| You can use both flat-file lookup types as well as relational lookup types. | It can be used with relational lookups. |
| It is possible to use relational operators such as =&=. | The dynamic cache supports only the = OPERATOR. |
| In both unconnected and CONNECTED lookup transformations, a static cache can be used. | You can use the dynamic cache only for connected lookups. |
