Multiple choice technology databases

You are working on a job in which a sequential file cannot be read in parallel. In an attempt to improve job performance, you first define a single large string column for the non-parallel sequential file read. Which stage may be used to parse the large string in parallel?

  1. The Column Import stage

  2. The Column Export stage

  3. The Make Vector stage

  4. The Split Vector stage

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

The Column Import stage in DataStage can parse a large string column in parallel, making it ideal for this scenario. When you read a sequential file as a single string for performance reasons, Column Import can then parse that string into multiple columns using parallel processing. Column Export is for the opposite operation (combining columns), while Make Vector and Split Vector are for different purposes.