ODS Delta problem

[Former Member]

Hello,

I’m extracting data from ODS to cube using delta update. The initial update finished successfully with 2M records. The second update (delta update) was failed because of some locks. I entered the monitored and set the status of the delta to red. Than I entered the ODS and deleted the V from the “data mart status of the request”. I tried to extract delta update again but now it is extracting more than 5M records!!!!!! The last delta update of the ODS (the data which is not updated in the cube yet) is only 30000 records. No-way it become to 5M records!!!! it is more than the initial update!!!

Please Help!

David

[Former Member · Accepted solution]

This is strange behavior sometimes, I can't tell why, but our support team had exactly the same issue. Someone delta is messed up.

1. Delete Init from ODS to cube.

2. Delete the last delta in the ODS which needs to be updated to the cube.

3. Do Init without data transfer from ODS to Cube.

4. Load Delta from ODS to cube, which basically should bring zero record. Make sure you get zero record.

5. Reconstruct the deleted Delta in the ods.

6. Do Delta again, that should reset the Delta init and should bring only the new records.

That is the perfect solution, just did that a couple weeks ago.

thanks.

Wond

[Former Member]

Hi David

First you delete the last delta load and init too and again load init by checking the Without Data Transfer it will exactly fetch one record and after you do the delta load for that cube it will fetch 0 records.