Skip to Content
0
Former Member
Jun 29, 2011 at 06:42 PM

Impact of Changing Data Package Size with DTP

1654 Views

Hi All,

We have delta dtp to load data from DSO to infocube. Default data package size with dtp is 50,000 records.

Due to huge no of data, internal table memory space is used and data loading get fails.

Then we changed the data package size to 10,000, which executes the data load successfully.

DTP with package size of 50,000 took 40 minutes to execute and failed, but DTP with package size of 10,000 took 15 minutes (for same amount of data).

Please find below my questions:

Why a DTP with bigger size of packet runs longer than a DTP with lower packet size ?

Also by reducing the standard data package size 50,000 to 10,000, will it impact any other data loading?

Thanks