Computer Science homework help

Use the OLTP logical schema below to build data warehouse consisted of two data marts. You will need to import the final exam data code for the OLTP logical schema and develop ETL process in SSIS. Your tables should meet these requirements:
 
– DimDate table has DateKey values ranging from 19960704 to 19980603 (YYYYMMDD integer data type). If you use Flat File or Excel Data Source to import datekey data, include the data source file in the submission also
– DimDate table should have EnglishZodiacSignMonthName (varchar data type), CalendarYear (INT data type), Quarter (INT data type), LeapYear (BOOLEAN data type), and IsMortherDayHoliday (BOOLEAN data type) attributes
– DimProduct should contain product name, supplier name, category name, unit price, and discontinued
– AccumulatingOrderFact has 3 foreign keys – OrderDateKey, RequiredDateKey and ShipDateKey, and one degenerate dimension attribute – OrderID. Note that the your 3 datekeys should allow to have ‘Null’ value if the order does not have either order date, required date, or ship date
– PeriodicSnapShotMonthlyOrder has 2 foreign keys – MonthKey and ProductKey
– Correct ETL process to create 3 fact measures for AccumulatingOrderFact
– Correct ETL process to create 3 fact measures for PeriodicSnapShotMonthlyOrder

Solution:

15% off for this assignment.

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

Why US?

100% Confidentiality

Information about customers is confidential and never disclosed to third parties.

Timely Delivery

No missed deadlines – 97% of assignments are completed in time.

Original Writing

We complete all papers from scratch. You can get a plagiarism report.

Money Back

If you are convinced that our writer has not followed your requirements, feel free to ask for a refund.