1. Why is time almost always a dimension in a data warehouse? 2. Describe the ma
ID: 3701275 • Letter: 1
Question
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
Product
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.
EmpID LastName Department 001 Briny Sales 002 Stons Development 003 JonesProduct
004 Wayne Marketing 005 Kirk AccountingExplanation / Answer
Question1-
Solution-As the Time-variant information is typically always found in many different applications or you can say most of the application . Hence, this information is also included in data warehouse and so time is always a dimension of data warehouse.
Note-For other questions to be answered please provide as seprate questions
Thankyou
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.