Error: Output column <column name> of Lookup <transformation name> (that is trying to find one to share) was not found in Lookup <transformation name> (with existing cache) even though they have the same cache file name prefix <cache file name> and <cache file name> needs to be refreshed / updated.
The second Lookup transformation uses a subset of condition columns of the first Lookup transformation. However, the second Lookup transformation needs to refresh the cache. The number of condition columns must be the same.
If you do not want to share the cache, change the cache file name for one of the Lookup transformations. If you want to share the cache, make sure the shared transformations use the same ports in the lookup conditions.
