【表格建模系列】三、添加数据

添加如下表（注意取消列出字段）：

 

DimCustomer:

SpanishEducation, FrenchEducation, SpanishOccupation, FrenchOccupation

 

DimDate: 

DateKey, SpanishDayNameOfWeek, FrenchDayNameOfWeek, SpanishMonthName, FrenchMonthName

 

DimGeography: 

SpanishCountryRegionName, FrenchCountryRegionName, IpAddressLocator

 

DimProduct:

SpanishProductName, FrenchProductName, FrenchDescription, ChineseDescription, ArabicDescription, HebrewDescription, ThaiDescription, GermanDescription, JapaneseDescription, TurkishDescription

 

DimProductCategory: 

SpanishProductCategoryName, FrenchProductCategoryName

 

DimProductSubcategory: 

SpanishProductSubcategoryName, FrenchProductSubcategoryName

 

FactInternetSales: 

OrderDateKey, DueDateKey, ShipDateKey

 

保存。