Which one of the transformations below does not use index and data cache
-
Aggregator
-
Lookup
-
Joiner
-
Expression
Reveal answer
Fill a bubble to check yourself
D
Correct answer
Explanation
Expression transformation processes data row-by-row without caching. Aggregator, Lookup, and Joiner all require data/index caches for grouping, lookups, and joins. Expression has no cache overhead since it only transforms individual rows based on expressions.
AI explanation
Transformations like Aggregator, Lookup, and Joiner build an internal cache (index and data cache) to hold rows in memory for grouping, matching, or joining operations, since they need to compare incoming rows against previously seen rows. The Expression transformation processes each row independently with no need to remember prior rows, so it doesn't require any caching.