Question:
Hi,
We are extracting data from a datasource in R3 to BW. We have data transfer setings of 20MB per packet.
Our extraction of 234000 records when we looked in PSA are divided into 3 packets on of 60,000, another of 133,000 and the last one of 41,000 records. When the ODS is getting loaded, it literally struct at packet #2.
I do not understand, why so different sizes of packets?
Which way is the best to set the data transfer parameters? Is it either by the data size or it should be by number of records?
Thanks in advance
Answer:
you've got two limits : number of lines and size
if you are below your number of lines, the number of record depends on the weight of your records;
if in the first part of the load you have less long fields than in the second part, the first part will have a higher number of records
search the forum on "transfer parameters" or something similar
Ch
_________________
_
There are only 10 types of people in the world :
those who understand binary and those who don't.