When you have multiple Lookup transformations in a mapping, the first lookup creates a cache file. The second lookup tries to use the same cache file, but cannot because the condition does not match. Because both lookups use the same cache file name, the second lookup cannot create a cache file.