Skip to Content
Former Member
Jan 24, 2012 at 03:41 PM

Delta from ODS to Cube



We have a scenario where data is coming from Application 11 for SD. Data Flow is as follows :-

2lis_11_VASCL,& 2lis_11_V_SCL --> DSO1 - Delta to DSO2->Delta to Cube

Till August 2011 all the data loads were Full and hence in the process chain all the change logs were deleted on daily basis. But from August it was changed to Delta from DSO1 onwards. But there was no change in the process variant which was deleting the changelogs of DSO 1 and DSO 2. Now we have found that many of the values in the cube are not from August onwards.

If we do a full load from data source to the DSO 1 and then delta to DSO 2 and then again Delta to Cube will this cause any problems? Will it resolve the issue? Any other suggestions regarding the situation will be appreciable.

Obviously we have now change change log deletion variant and now it only deletes the change logs which are more than 7 days older.