Which of following statements is valid for Dynamic lookups?
A. Dynamic caching cannot be enabled on a lookup that returns multiple rows per search
B. A dynamic lookup can only be used with insert mappings, i.e. no update strategies are allowed and the session should be configured as Insert
C. A dynamic lookup must be cached and persistent
D. It is possible to update and delete records in a dynamic lookup
A is the correct
Following are the guidelines when you configure the Lookup transformation to return multiple rows:
– You can cache all the rows from the lookup source for cached lookups.
– You can customize the SQL Override for both cached and uncached lookup that return multiple rows.
– You cannot use dynamic cache for Lookup transformation that returns multiple rows.
– You cannot return multiple rows from an unconnected Lookup transformation.
– You can configure multiple Lookup transformations to share a named cache if the Lookup transformations have matching caching lookup on multiple match policies.
– Lookup transformation that returns multiple rows cannot share a cache with a Lookup transformation that returns one matching row for each input row.