Notifications
Clear all
Topic starter
12/10/2022 11:27 pm
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.
Suggested Answer: A,B,C