Error: Dynamic Lookup <transformation name> needs to delete a cache file <cache file name> that was created by a Static Lookup <transformation name> in an earlier TLOG using different parameters.
In a previous target load order group in a mapping, a static Lookup transformation created a cache file. A dynamic Lookup transformation uses the same cache file name and cannot delete it.
Use unique cache file names for the transformations.