Multiple choice technology

A Data Stage job is sourcing a flat file which contains a VARCHAR field. This field needs to be mapped to a target field which is a date. Which will accomplish this?

  1. Use a Column Exporter to perform the type conversion.

  2. Data Stage handles the type conversion automatically.

  3. Use the TimestampFromDateTime function in a Transformer.

  4. Use the Modify stage to perform the type conversion.
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The Modify stage performs explicit data type conversions in DataStage. It can map a VARCHAR source field directly to a Date target field using type specification attributes. Column Exporter is for pivoting/delimiting, not type conversion. DataStage does not automatically convert between incompatible types. TimestampFromDateTime is for timestamp manipulation, not string-to-date conversion.

Keep practicing — related questions