Which Data Type is good..?

[Former Member]

Hi All,

I have a file with 30,000 rows, each represent a item. Iwould like to know which way of the following data type is good? or having advantage over other.

Case-1:

ITEM_LIST_DT

.......|_ItemList occurs 1 time

.......... |_Item occurs 0 to unbound

.............. |_Name String occurs 1 time

.............. |_Desc String occurs 1 time

.............. |_Number String occurs 1 time

.............. |_Code String occurs 1 time

Case-2:

ITEM_LIST_DT

.............. |_Item occurs 0 to unbound

.................. |_Name String occurs 1 time

.................. |_Desc String occurs 1 time

.................. |_Number String occurs 1 time

.................. |_Code String occurs 1 time

Does xi is going to push all the records at a time in the first case?

[Former Member · Accepted solution]

Hi,

I think case 2 should be a good choice. Yes XI going to pick up the file at one shot and then will start mapping so it will push the data in one go.

Thanks,

Prateek

[MichalKrawczyk]

Hi,

>>>Does xi is going to push all the records at a time in the first case?

I guess it will do it in both cases

as you have "0 to unbound" occurance at item tag level

Regards,

michal

[Former Member]

If i have very big file like 62MB, How can i make XI read in chunks?

Thank you

Ganges Leaves

[moorthy]

Hi Ganges,

There is a option of Record Sets Per messages in the File Adapter. You can use this.

Pls look into this Blog-

/people/sravya.talanki2/blog/2005/11/29/night-mare-processing-huge-files-in-sap-xi

/people/alessandro.guarneri/blog/2006/03/05/managing-bulky-flat-messages-with-sap-xi-tunneling-once-again--updated

Second option is again splitting the files before XI picks up the file. Again this can be done using Scripts.

Hope this helps,

regards,

Moorthy

[moorthy]

HI Ganges,

Case 2 is better. Because you can get the xml as nested as shown in the Data Type.

If you go with Case 1, then it is of type one more Wrapper class. This can be used if you have different structures under ItemList occurs 1 time.

Hope this helps,

regards,

Moorthy