Skip to Content
1
Mar 22, 2014 at 01:13 PM

Performance issue in loading

605 Views


Hi All,

We have an DSO (Conslidation DSO )- Cube loading and that load runtime is 7H 45m 19s. Daily its a full load happeneing. And source DSO has multiple loadings to different targets. In DTP there is a filter on some four fields which is used to restriced the loading of data.

1. start of extraction in data package is taking 1 Hours 13 Minutes 9 Sec.

2. Records inserted - 5.951.497.

3. No logic is there in transformation.

4. key fields are the sales document no and sales order item.

5. Secondary index are avalible for DSO but those fields which is used in DTP filter is not there.

How i can optimize the loading runtime? 😕

Thanks,

Siva