Which transformation does not use index and data cache memory?
-
Aggregator
-
Rank
-
Lookup
-
Sorter
D
Correct answer
Explanation
Sorter transformation operates in a streaming fashion and doesn't require cache memory. Aggregator and Rank transformations need data cache to store group data, and Lookup needs index and data cache for lookup tables. Sorter processes data row by row without storing intermediate results.