Convert 1 file into 3 files

Details:
Col
-----
C1
C2
C3
C4
C5
C6
C7
C8
C9
C10
we want to generate output like:
Col1 Col2 Col3
C1 C2 C3
C4 C5 C6
C7 C8 C9
C10
Can anyone please help me on this scenario?

Interview Candidate
Sep 3rd, 2017
3
10782

DataStage

Answer

First
Prev
Next
Last

Showing Answers 1 - 3 of 3 Answers

dattu

Dec 26th, 2017

partition by round robin

prashant

Nov 25th, 2018

Partion by Range

Hemant

Mar 4th, 2019

Use below constraints in xfm to move the data into 3 different columns. Make the xfm partition to run sequential.
mod(@inrownum,3) = 1
mod(@inrownum,3) = 2
mod(@inrownum,3) = 0
This will move first record to first output file, second to second and third record to third reference link.