Page 1 of 1

Splitting input data into files

Posted: Fri Feb 16, 2007 12:26 am
by vij
Hi all,

I got a new requirement which says :

The input txt file from Unix box should be read by datastage and should be splitted in to multiple XML files based on the size of the data, for an eg., 256Kbytes.

Is it possible to achieve this from datastge? If so, please let me know.

Thanks in advance!!

Re: Splitting input data into files

Posted: Fri Feb 16, 2007 12:38 am
by sudeepmantri
[Splitting of data can be done thru stages named as Head and Tail. U can Mention the Percentage of records that goes to one file and the rest goes to the other

Posted: Fri Feb 16, 2007 12:41 am
by kumar_s
Not based on size but can be done based on records in DS level.
Or you can use Split command in OS level and use DS to convert it into XML.