Skip to Content
Former Member
Jul 04, 2007 at 04:56 PM

ODS Delta problem



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!