Description of a data data warehouse Assignment

Description of a info data w arhouse - Assignment ExampleData from different sources are converted into a common initialise in the data warehouse, therefore, each department will produce results that are in line with each the others.Furthermore, a data warehouse will be of great importance during data recovery. If a disaster occurs in the transactional database, it will be easy to restore all data, all if not all, that which is of importance, to the transactional database from the warehouse.This table is use to store information about different tables from the dimensions table, which embroil CustomerKey, SupplierKey, seasonKey, ProductKey, OrderID, Required_DateKey, UnitsOnOrder, ProductPrice, Shipped_DateKey, Quantity, TotalPrice, ShipperCompany, ShipperPhone, InsertAuditKey and UpdateAuditKey.The table contains key values of different dimensions tables. ProductKey, SupplierKey, DateKey, UnitPrice, UnitsInStock, UnitsOnOrder, ReorderLevel, UnitsSold, InsertAuditKey, UpdateAudit Key. 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 table.The table has CustomerKey as the surrogate key for the table, CustomerID as the business key. Other customer information stored in this table include FirstName, LastName, TitleOfCourtesy, CompanyName, Address, City, Region, PostalCode, PostalCountry, Phone, Fax, Description, IsCurrent, EffectiveStartDate, AffectiveEndDate, InsertAuditKey, UpdateAuditKey.The other employee information stored in the dimension employee table include LastName, FirstName, Title, TitleOfCourtesy, BirthDate, HireDate, Address, City, Region PostalCode, Country, HomePhone, Extenision, Notes.Other information stored in this table inc lude Day,