In this scenario, which three statement s are correct about the data flow of the ‘Database Lookup step?

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.

View Answer

Answer: A,B,C