Datasheet

Figure 1-2: Star schema
Figure 1-3: The ETL system
Store
Costs & Sales
(SQL Server)
SSIS ETL
Warehouse
Orders & Costs
(Oracle)
Star-Schema
(SQL Server)
Corporate Data Warehouse
Repor ting
Applications
Corporate
HR & Budget
(DB2 & Excel)
Cubes
(Analysis
Services)
BI Solutions
ProductKey
ProductAlternateKey
ProductSubcategoryKey
WeightUnitMeasureCode
SizeUnitMeasureCode
EnglishProductName
SpanishProductName
DimProduct
ProductKey
OrderDataKey
DueDateKey
ShipDateKey
CustomerKey
PromotionKey
CurrencyKey
SalesTerritoryKey
SalesOrderNumber
SalesOrderLineNumber
RevisionNumber
OrderQuantity
UnitPrice
FactInternetSales
CustomerKey
GeographyKey
CustomerAlternateKey
Title
FirstName
MiddleName
LastName
NameStyle
BirthDate
MaritalStatus
Suffix
Gender
EmailAddress
YearlyIncome
TotalChildren
DimCustomer
TimeKey
FullDateAlternateKey
DayNumberof Week
EnglishDayNameOfWeek
Spanish
FrenchDayNameOfWeek
DayNumberOfMonth
DayNumberOfYear
WeekNumberOfYear
DimTime
CurrencyKey
CurrencyAlternateKey
CurrencyName
DimCurrency
PromotionKey
PromotionAlternateKey
EnglishPromotionName
SpanishPromotionName
FrenchPromotionName
DiscountPct
EnglishPromotionType
DimPromotion
5
Chapter 1: Getting Started
04_134115 ch01.qxp 4/24/07 6:40 PM Page 5