Cube

A Datastore versus a Staging Cube

One of the data modeling constraints of a DataStore is the limitation of ‘How many characteristics you can put in the key field list?’. It is a design strategy that has been enforced from the database layer up to the application layer. The BW application is intentionally keeping the direct correlation between the object model…   [read more…]

DataStore

DataStore Limitations and Rogue Records

You have gone to the effort of implementing the right tool for the job; a DataStore, not a staging cube. Generating true delta records in the data model has improved the nightly load window. Using the fundamental feature of a DataStore, the change log now contains a simplified ‘action list’ of real changes, eliminating all…   [read more…]