Dylan’s BI Study Notes

My notes about Business Intelligence, Data Warehousing, OLAP, and Master Data Management

  • About me

    I am a senior development manager working for Oracle BI Applications development. My job involves the common area, including data warehouse modeling and dimension conformance. I was involved in Oracle E-Business Suite Financial Architecture, Oracle Customer Hub, and Oracle Fusion Projects product development in the past. Disclaimer: Opinions expressed in this blog are entirely my own and do not reflect the position of Oracle.

  • Blog Stats

    • 125,389 hits

  • My Tags

Data Warehouse Design

Here are the design patterns or tips I identified by studying the various books and release world data warehouses.

Design Tip: Key for the Date Dimension

Design Tip: Use minidimension to handle rapidly changing monster dimension