Multiple choice technology

While using Incremental Aggregation it is advisable to use sorted input option

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

When using Incremental Aggregation in Informatica, data should NOT use the sorted input option. Incremental aggregation caches aggregated values and processes unsorted input efficiently. Sorted input is only beneficial for standard aggregate transformations where the aggregator can optimize by detecting grouped data. For incremental aggregation, sorted input provides no benefit and can interfere with cache-based processing.

Keep practicing — related questions