1. Why is time almost always a dimension in a data warehouse?

2. Describe the major components of a data warehouse architecture.

3. The following table shows data as of 4/2/1018

EmpID	LastName	Department
001	Briny	Sales
002	Stons	Development
003	Jones	Product
004	Wayne	Marketing
005	Kirk	Accounting

On 4/3/2018 the following transactions occur

Employee 002 transfers to Marketing department

Employee 004 transfers to the Product department

Employee 003 resigns from the company

On 4/4/2018

New employee 006 is added to the file. Name: Majors, Department: Sales

Employee 001 changes name to Briny-Leopold

Construct tables for 4/3/2018 and 4/4/2018 reflecting the above transactions. Assume the data is transient. Repeat assuming the data is periodic.