BI: Building the Data Warehouse Lesson 3

Designing a New Data Warehouse Blue Print
Korry Kelley | Lesson 3


In this lesson I have loaded and reviewed the NorthwindLite DB and determined what fields I needed to include in my data warehouse blue print. Please see details illustrated and called out below:

The image above illustrates that I’ve loaded the NorthwindLite OTLP and table/field associations and key connectors.

The image above illustrates the source NorthwindLite OLTP fields and naming convention

    

The image above illustrates the fields I chose to include from the source into my data warehouse blueprint

§  I chose to convert all Key Fields to int type

§  Any ‘Money’ types I chose to convert to ‘decimal(18,4)’ to avoid any compatibility issues

§  For any char types in the source I chose to convert to either ‘nvarchar(30)’ or ‘nvarchar(35)’ for consistency (Size) and compatibility (Unicode)