Normalization in data warehouse


Q1. Data warehouse is a blend of technologies. Do you concur with this statement? Illustrate your arguments.

Q2. Describe in detail the merits and demerits of Top-Down versus Bottom up approach of the data warehouse design.

Q3. What do you mean by Partitioning of data? Describe the ways to carry it out by giving appropriate illustrations.

Q4. Describe the warehouse architecture in detail.

Q5. List out the main functions and services for the information delivery? Explain each in brief.

Q6. A dimension table is wide; the fact table is deep. Illustrate.

Q7. Describe the merits of STAR schema.

Q8. Describe the term Normalization in data warehouse. List all its merits.

Request for Solution File

Ask an Expert for Answer!!
Database Management System: Normalization in data warehouse
Reference No:- TGS011512

Expected delivery within 24 Hours