How to split Large file into Multiple small files..

[Former Member]

Hi,

My source file is simple XML structure...and target side also i need to send in XML files .. but in the source file I'm getting all the data at a time.. so source file is more than 1000 records.. but i want to process 50 records at a time...

bu using FCC (RecordSet per Message) we can solve this.. but I dont want to do any File conversion.. i want to send in XML file only...

for this.. how we can handle....

Regards

Jain

[Former Member]

HI Jain

Already solution is given by Raj that will work for you.

You can follow this blog as well

Thanks

Gaurav

[justin_santhanam]

Jain,

You can split 50 records at mapping level and send small files, right?

raj.

[Former Member]

HI RAJ,

Mapping level how can we splitt the source file... can u give me any idea.. and is there any other option to split the large file into smaller files...

Regards

Jain

[justin_santhanam]

Jain,

If it's content conversion, then we can think of Record sets per message, but ur source is XML, hence we need to go only for mapping level split. What is ur source structure?

raj.

[Former Member]

Hi Raj,

yaa my source file ... is XML format..and my target side also i need XML format... only...

DT_SOURCE

. .Data

. . .No

. . .Name

. . .City

Regards

Jain

[justin_santhanam]

Jain,

Please see the below screenshots.

http://www.flickr.com/photos/23855877@N07/2991137391/sizes/o/

http://www.flickr.com/photos/23855877@N07/2991137441/sizes/o/

http://www.flickr.com/photos/23855877@N07/2991988028/sizes/o/

http://www.flickr.com/photos/23855877@N07/2991988084/sizes/o/

For No, Name, City Map Directly.

In the example, I've given 5 records to split. If you want 50 records to split, then instead of 5 give 50 in the constant.

raj.