Which of the following is/are an Active transformation
-
Sorter
-
Connected Lookup
-
Expression
-
Unconnected Lookup
A
Correct answer
Explanation
Active transformations change the number of rows passing through them. The Sorter transformation is active because it changes the row order. In contrast, Expression transformations are passive (same number of input and output rows), and Lookup transformations can be active or passive depending on whether they're connected or unconnected.