Data Driven Design with Agile for Data Warehousing
An introduction to using Data Driven Design and the Agile Project Methodology to quickly deliver a Data Warehouse.
The Dimodelo Data Warehouse Studio code generation process
This post discusses in detail how Dimodelo Data Warehouse Studio generates code to create and manage a Data Warehouse, including creating and managing Data Warehouse Databases, Tables and ETL procedures. While Dimodelo Data Warehouse Studio has a set of predefined Generation Templates and Generation Providers , it is also extensible, allowing end users to create their own Generation Templates and Generation Providers.
Defining a Dimension with Smart Keys
While conventional wisdom (and Kimball) says that using meaningful identifiers for surrogate keys is a bad idea, there are some exceptions where it makes sense. Typical examples include: Calendar. An example of a Calendar smart key is – year, month, day e.g. 20110721. A DateTime value can be converted to this date format using this statement convert(char(8),date, 112)….
Creating and Using a Derived Staging Table
What is a derived staging table? It’s a table created in your Staging database that derives its data from other already existing Staging tables. Its useful for creating aggregations, or allocations of data prior to the transform and load process into your Data Warehouse. It can also be useful for tables that don’t have any…