Static cache:

We can not insert or update the cache.

Dynamic cache:

We can insert rows into the cache as we pass to the target.