Package size in DTP

[Former Member]

Hi,

In the transformation from DSO1 to DSO2, I have requirement to split a single record into multiple ones based on business logic. This I have coded in the End routine.

The DSO1 has 8000 records which results in close to 1 million records in DSO2. These 1 million records are written into 1 single package, because the initial package had only 8000 records. Now my question is do i need to split into packages of 50000 during runtime. If yes, how it is done ?.

I appreciate your responses.

Thanks,

Suresh

[Former Member · Accepted solution]

you wanna splt the size of Dtp .....on the dtp it self if you have full or delta underneath it says package size change it to 50000.

[Former Member · Accepted solution]

I dont think you understood it correctly. During runtime in the end routine, i am changing the 8000 odd records from the DSO1 to 1million odd records. So the result_package is 1 million records.

[Former Member · Accepted solution]

Hi,

No , Its not possible to change it in the runtime. In DTP you can only set the package size for the whole process in DTP Extraction tab. However to speed up your process in this case you can reduce the package size to say 2000 and increase the number of parallel processes to 4(theough GOTO -> Settings for Batch Manager for DTP).

Navesh

[Former Member · Accepted solution]

Hi Sri ,

Why not you just reduce package size in start .

Select package size 1000 or even less( 200) based on no of records getting created .

Use semantic key to group characteristics that your routine is using to generate multiple values .

For target their is no restriction as package should update only 50000 records but You will get dump if memory will not be available to handle intermediate result so in start itself reduce package size.

Regards,

Jaya Tiwari

[former_member188080]

Hi,

This record split would have happened at routine level.

so see if there is logic to split the records in start routine,end routine or field level routine.

I don't see it is anything to do with package size..

Thanks and regards

Kiran

[Former Member]

Thanks Jaya and Navesh..... that is a good solution... I will reduce the package size initially ... I split each record close to 120 records, so I will make my initial package size based on this calculation...

Thanks,

Suresh...