Skip to Content
0
Former Member
Dec 06, 2009 at 03:34 AM

DTP settings

36 Views

I am using BI 7.0, I am doing a reload activity in which i am loading from one DSO to Another DSO.

In my source DSO there are around 30 million records.

The Problem:

When i executed the DTP with ordinary settings as delta, it was not progressing.

So i cancelled the load and ran the DTP with settings"Get All New Delta Request by Request from Active Table (Without Archive). "

After starting the load, i change the settings back to normal.i.e "delta load from changelog table".

Because i started the load with ""Get All New Delta Request by Request from Active Table (Without Archive). ".

In first request it picked around 1,80,000 records and completed.

but in the second request which started automitically because of the settings, it has picked around 8,50,000 records till now and stil progressing.

my question is why it is picking so many records in second request.

Did it happened because i have changed the settings back to normal from "Get All New Delta Request by Request from Active Table (Without Archive)" after starting the load.