Multiple choice technology platforms and products

If we use sorted input in an aggregator transformation and do not sort data correctly, then_________.

  1. integration service sorts the data

  2. the session fails

  3. gives unexpected results

  4. gives the aggregated output
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

When you specify sorted input for an aggregator transformation but don't actually sort the data correctly, the Integration Service fails the session because it expects pre-sorted data to optimize aggregation.

Keep practicing — related questions