Which one of the transformations below does not use index and data cache
-
Aggregator
-
Lookup
-
Joiner
-
Expression
D
Correct answer
Explanation
Expression transformation performs row-level calculations and transformations using input values to create output values, but does not require any caching. Aggregator uses index and data cache for grouping and aggregation. Lookup uses index and data cache to store lookup data. Joiner uses index and data cache for the join operation. Expression is the only one that processes each row independently without needing to cache data for comparisons or lookups.