The Use of a Data Warehouse - Assignment Example

Download file to see previous pages The table contains key values of different dimensions tables. ProductKey, SupplierKey, DateKey, UnitPrice, UnitsInStock, UnitsOnOrder, ReorderLevel, UnitsSold, InsertAuditKey, UpdateAuditKey. The Product, Supplier, and Date keys are surrogate keys in the FactInvetory table. The InsertAuditKey and the UpdateAuditKey are foreign keys from the FactOrder table. The table contains information about keys, the SK_EmployeeKey, SK_TerritoryKey, and the SK_DateKey. All these are surrogate keys referencing EmployeeKey TerritoryKey and DateKey from different dimensions tables.   The table has CustomerKey as the surrogate key for the table, and CustomerID as the business key. Other customer information stored in this table include: FirstNtablesLastName, TitleOfCourtesy, CompanyName, Address, City, Region, Poland steal code, PostalCountry, Phone, Fax, Description, IsCurrent, EffectiveStartDate, AffectiveEndDate, InsertAuditKey, UpdateAuditKey. The other employee information stored in the dimension employee table includes LastName, FirstName, Title, TitleOfCourtesy, BirthDate, HireDate, Address, City, Region PostalCode, Country, HomePhone, Extension, and Notes.   Other informatioincludesd in this table includes Day, DaySuffix, DayOfWeek, DOWInMonth, DayOfYear, WeekOfMonth, Month, MonthName, Quarter, QuarterExtension, SandardDate, HolidayText, InsertAuditKey, and UpdateAudtKey. This table stores information about audits of different tables. It includes AuditKey which is the surrogate primary key for this table and ForeignAuditKey which is a foreign key to itself.   ...Download file to see next pages Read More