In a PDI transformation you are retrieving data from a large lookup table using a Database Lookup step from improve performance, you enable caching in the stepand use the Load all data from table option.
In this scenario, which three statement s are correct about the data flow of the ‘Database Lookup step? (Choose three.)
A . When caching is enable, only rows with matching lookup values will passed through.
B . There must be enough allocated heap space to store the lookup fields allocated heap space to store the lookup fields in memory.
C . Cached comparisons are case sensitive.
D . Every input row must have only one matching row in the lookup table
E . Only one matching row is used from the Lookup table.
Answer: A,B,C
Latest HCE-5920 Dumps Valid Version with 60 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund