Restricting number of records in data package

[Former Member]

hey guys

I want to restrict the number of records in a data package. where can i set this speciafically for one info package? is there any way?

regards

Sriram

[Former Member]

Yeah it is..

I even tried with 1kb.. but atill every records are coming in same data package 1. At source system level i think have to ckeck..

Thnx for the messages anyways

regards

Sriram

[Former Member]

Hi Sriram,

Marko's suggestion is right except that Max. size of a data packet is set IN ROWS, not in Kb.

Best regards,

Eugene

[Former Member]

Eugene,

Not in the BW-InfoPackage: 'Maximum size of a data packet in kilo bytes'. Size means nothing in rows; 2 rows of 2000 bytes logically have more impact on dataload then 300 rows of only 10 bytes.

Regards,

Marco

[Former Member]

Hi Marco,

In BW-InfoPackage the column for setting max size is read as "Maximum size of a data packet in rows". You can experiment with this setting. It is exactly 'number of rows', not size in Kb.

Best regards,

Eugene

[Former Member]

Thnx prasad..

But i wanted to do it for a specific infopackage.. but ur suggestion works for all infopackages right!!.. anyways thnx for that.. assigned some points to u too

Regards

Sriram

[Former Member]

Hey that for ur fast reply.. assigned some points..

But i did the same.. i have one data package with 34555 records.. the size was mentioned as 100kb. i reduced it to 10 kb and rescheduled. but once again it came only in one data package. still i reduce it from 10 to 1kb?

Regards

Sriram

[Former Member]

Sriram,

Maybe it conflicts with the settings on OLTP-side? Maybe it overrules your 10kb setting. SAP however recommends sizes between 10000 & 50000 kb in order to reach opimal performance.

Cheers!

Marco

[former_member181955]

Hi Sriram,

We can restrict the no of records for data package in the OLTP System side. For example if u r extracting data from R/3,see the following steps

1. Log on to R/3

2. Go for SBIW

3. Expand Data transfer to SAP Business Information

warehouse

4 .Expand General settings

5. Execute Maintain control parameters for data

transfer

6. u can see BW source system if it is already created.

If it is there , select it and go for change mode

then enter no of lines (records) u want .

7.If u don't see bw system then create it by clicking

on new entries , then provide all required details.

please let me know if it help u

Kind Regards

N.Prasad Babu

[Former Member]

Sriram,

In the InfoPackage goto Scheduler -> DataS. Default Datatransfer.

Here you can set Max. size of datapackage (kB), Nr. of datapackets per IDoc per Datasource.

So calculate # kB per record * # records you want to send and put the result in Max. size parameter.

Hope this helps.

Regards,

Marco