Description of a data data warehouse Assignment

Description of a data data warehouse - Assignment ExampleData from different sources are converted into a common format in the data warehouse, therefore, each department will produce results that are in line with all 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 non all, that which is of importance, to the transactional database from the warehouse.This table is used to store selective information about different tables from the dimensions table, which include CustomerKey, SupplierKey, DateKey, 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, UpdateAudi tKey. 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 backing 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,