Multiple choice technology

A customer must compare the value of a decimal field to that of an integer field to determine whether to drop a row of data. What would be the correct stage to use for this requirement?

  1. The Transformer stage

  2. The Switch stage

  3. The Filter stage

  4. The Compare stage

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The Transformer stage is designed for data transformations including conditional comparisons between fields of different types (decimal vs integer). The Filter stage only filters based on simple conditions, the Switch stage routes data based on value matching, and there is no standard 'Compare' stage in DataStage.