Referring to a lookup transformation: Which of the following statements are true and correct?
A. The caching of a flat file is optional if the data in the flat file is sorted
B. The lookup index cache file contains a searchable index of the records based on the lookup condition
C. When lookup caching is unchecked, PowerCenter will read from a locally stored cache file
D. The data cache contains all of the fields in the lookup transformation
Ref https://docs.informatica.com/data-integration/powercenter/10-4-0/transformation-guide/lookup-transformation/lookup-caches.html
I would say B,C,D instead. that three choices all look true.
correction: the original answer seems to be true, sorry