Multiple choice technology databases

Data driven option is present in which transformation?

  1. Normalizer

  2. Sequence Generator

  3. Union

  4. Update strategy
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The Update Strategy transformation is the only one with a Data Driven option. This option allows you to control how rows are treated (insert, update, delete, or reject) based on expression logic that evaluates the data content. With Data Driven enabled, you can use the DD_UPDATE, DD_INSERT, DD_DELETE, or DD_REJECT functions to dynamically determine row treatment. Normalizer pivots columns, Sequence Generator creates sequential keys, and Union combines sources - none have data-driven row treatment.

Keep practicing — related questions