Multiple choice technology

When you configure a session using Update Strategy transformations and a dynamic lookup cache, which is the correct combination of session properties

  1. a.select insert, select update and do not select delete

  2. b.treat source rows as data driven, select insert, select update as update and do not select delete

  3. c.treat source rows as data driven, select insert, select update and do not select delete

  4. d.treat source rows as data driven, select insert, select update,
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

When using Update Strategy with dynamic lookup cache, the session must be configured as data-driven to allow the Integration Service to interpret update strategy flags. The correct combination includes: treat source rows as data driven (enables update strategy processing), select insert (allows new rows to be added), select update as update (ensures updates use UPDATE not INSERT), and do not select delete (prevents deletion). This configuration supports both inserts and updates through the dynamic cache while maintaining cache-target synchronization.

Keep practicing — related questions