Multiple choice technology

In Dynamic Lookup Cache Integration Service reads a row from the source and updates the lookup cache by performing the below actions

  1. Inserts the row into the cache

  2. Updates the row in the cache

  3. Makes no change to the cache when configured the Lookup transformation to insert new rows only

  4. All of the above
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

In Dynamic Lookup Cache, the Integration Service performs different actions based on the row type and cache configuration: it can insert new rows into the cache, update existing rows, or make no changes depending on whether the lookup is configured for insert/update or insert-only. All three actions are valid in different scenarios, making 'All of the above' correct.

Keep practicing — related questions