1. What is the relationship between data warehouse and BI?
2. Compared to other popular ETL tools, what are the main advantages of SSIS? what are the main advantages of SAS Data Integration Studio?
3. Use examples to explain why we need a staging area in an ETL process?

4. Design a data warehouse for an application domain that you are familiar with. Make sure that the warehouse has a fact with associated levels
and measures, hierarchies. Several dimension tables (no need to draw diagram, just list the attributes of fact table and dimension tables, levels and hierarchies.

5. What is the difference between the KeyColumn, the NameColumn, and the ValueColumn for a dimension attribute in SSAS?

Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now

6. What is the objective of physical data warehouse design? Specify different techniques that are used to achieve such objective.

7. An online order wine company requires the designing of a datawarehouse to record the quantity and sales of its wines to its customers. Part of the original database is composed by the following tables:
CUSTOMER (Code, Name, Address, Phone, BDay, Gender)
WINE (Code, Name, Type, Vintage, BottlePrice, CasePrice,Class)
CLASS (Code, Name, Region)
TIME (TimeStamp, Date, Year)
ORDER (Customer, Wine, Time, nrBottles, nrCases)

Identify the attributes associated with the fact, identify the dimensions and their attributes.Convert this ER schema to star schema.

“Place this order or a similar order with Essay Writers 4Life and get an amazing discount”

Source link

"Our Prices Start at $11.99. As Our First Client, Use Coupon Code GET15 to claim 15% Discount This Month!!":

Get started