Q4 Single choice Mark for later 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 Correct answer