Skip to Content
0
Former Member
Feb 13, 2009 at 03:46 PM

Delta between ODS and cube with DTP

29 Views

Hi all,

We are doing testing of the delta between and ODS and a cube using the new DTP method. The DTP successfully sends the data into the cube from the ODS. The problem is that it does not take into account that the data was already sent to the cube from the ODS using the Datamart. The requests are starting with 8 and the transfer of data resets the initialization from the ODS and takes all existing data and sends it to the cube. The system sees the DTP as being an initial and not a delta request.

This is an issue for prod. as some cubes are extremely large and we don't want to reset the delta for all export datasources.

Has anyone found a work around for this?

Any help is appreciated!

Kathleen