Which is the costliest stage?
-
DB Stage
-
Transformer
-
Modify
-
Decode
B
Correct answer
Explanation
The Transformer stage is typically considered the most resource-intensive in DataStage because it operates row-by-row and allows complex custom logic. While database stages can be expensive due to I/O, the Transformer's per-row processing and transformation overhead makes it the costliest in terms of CPU and memory usage.