Skip to Content
0
Former Member
Oct 30, 2009 at 06:56 AM

First load with DTP with mode Delta

173 Views

Hello Experts,

I'd like some suggestions based on the following scenario.

DSO-A

- total records = 44,000,000

- with criteria X = 230,000

DSO-B (New DSO)

- due to this DSO is a new object. It is required to retrieve data from DSO-A with criteria X

- this means that the target records to be added are 230,000 records

- DTP for extracting data from DSO-A to DSO-B --> use Extraction Mode = Delta

Questions

- For the first time loading, how to extract data in small chunks at a time from DSO-A to DSO-B when Extraction Mode is set to Delta?

I have concerns on performance if data were loaded all at once with Extraction Mode = Delta. I do not want to interrupt other existing schedule jobs much.

After the first load, this DTP will be set to be run daily. The next day, data will not be loaded in huge amount again.

Any best practice on this.

All suggestions would be appreciated.

Thank you very much.

-WJ-