Dataset Splitting

[Former Member]

I have a Large dataset, which is already existed in Application Server.

My requirement is to read that Dataset and Split that dataset into Smaller datasets. The Splitting is done with respect to file size. I mean each splitted File contain same size.

EX: Assume i have a Dataset which is 100 MB in size. And my requirement is Split that Dataset into Smaller files eack contains 10 MB in size.So, one Large file is Splitted into 10 Smaller files.

Thanks in advance

malli

[Former Member]

Hi Malli

This depends on the kind of data we have on the original file. Following are the scenarios which i can presume:

Scenario1:

If each record in the dataset are independent then we might go by splitting at a fixed number of records.

Scenario2:

As far as me the worst scenario would be when we have transaction data something like HEADER and ITEMS. In this case, we need to go for special handling...

Consider an example where by we get the sales order details:

For a Sales Order we can expect:

1. Header Details

2. Items

3. Partners

4. Schedules

5. Conditions...

Kind Regards

Eswar