Multiple choice technology

While using an aggregator and an update strategy in the same pipeline

  1. The aggregator must come before the update strategy.

  2. The update strategy must come before the aggregator.

  3. The aggregator can come before or after the update strategy and vice versa.

  4. An aggregator cannot be used with an update strategy in the same pipeline.

  5. The update strategy must always use DD_UPDATE when used with an aggregator.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

An Aggregator (which groups and reduces rows) and Update Strategy (which flags rows for insert/update/delete) can be placed in either order in the pipeline. The order depends on business logic - you might aggregate first then flag the aggregated rows, or flag individual rows then aggregate. Both orders are valid depending on the use case.

Keep practicing — related questions