5

Data Store-only DWH

We use TX in a particular way: all the heavy work is done in the stage and standardized views in the stage are used as a basis for a data movement.

This effectively reduces the DWH to a simple data store which is then used to populate semantic models, QLIK models and OLAP cubes.

To reduce the size of logging and the size of the database, it would be nice to have a data-store only mode for the DWH which is basically the equivalent of truncating all RAW tables and inserting directly in the Valid tables. And by preference use bcp for a data movement instead of INSERT INTO to reduce logging.

2 comments

Please sign in to leave a comment.