We have a design where we have a Cube on top of cube. We want delta loads for the same (Cube 1 to Cube 2). We want to compress data in Cube 1 before loading to cube 2.
What has happened is that for dataloads for days Dec 1 - Dec 15 to Cube 1, we had compressed the Cube 1 and days Dec 16 - Dec 31 data was uncompresssed. We did an Initialization on Jan 1 from Cube 1 to Cube 2.
When we reconciled the data with SAP, we are way way off. I'm thinking it might have to do with partial compressions. Please let us know your views. How would the Init would have worked in the above scenario as some data was in F table and some in E table?
Looking forward to all of your views/suggesstions.
Regards and Thanks,