Part IV: Advanced Techniques

Part IV, the final part of the book, explores six advanced techniques in dimensional data warehousing that you may need to use to meet user requirements. The six techniques are

• Non-straight sources

• Fact-less facts

• Late arrival facts

• Dimension consolidation

• Accumulated measures

• Band dimensions