Customer Service Chat
Get quote & make Payment
datawarehouse, Database Management System
1) Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pictorial form so that it is easy to understand.
a. Finance cube (3 hours to build)
b. Warranty cube (4 hours to build)
c. Order cube (2 hours to build)
d. Customer master data (30 min run time)
e. Vendor master data (60 min run time)
f. Product master data (60 min run time)
g. Other Master data (2 hour run time)
Finance and Order cubes cannot run together.
2) Above cubes are used by NA and EU users, NA users will only use NA data and EU users will use only EU data but Master data is common for both NA and EU. The requirement of availability stays same for NA (6AM CST) and for EU reports/cubes should be available by 6am CET.
What changes you need to make to the job scheduling proposal of Question 1 to meet the requirement of Question 2?
CST – NA Central Standard Time
CET - EU Central European Time.
Posted Date: 4/1/2013 7:47:48 AM | Location : USA
Ask an Expert
datawarehouse, Assignment Help, Ask Question on datawarehouse, Get Answer, Expert's Help, datawarehouse Discussions
Write discussion on datawarehouse
Your posts are moderated
Write your message here..
Lossless-join decomposition, Lossless-Join Decomposition Let us sh...
Lossless-Join Decomposition Let us show an intuitive decomposition of a relation. We require a better basis for deciding decompositions since intuition may not always be r
When is update_statistics command used, When is UPDATE_STATISTICS command u...
When is UPDATE_STATISTICS command used? - When processing of large data is done, this command is used. - Whenever large number of modification, deletions or copy takes place
Differentiate sub-class and super-class, Differentiate sub-class and super-...
Differentiate sub-class and super-class? The specialization of a class is known as subclasses.eg: employee is a subclass of person and teller is a subclass of employee. Convers
What creates while a primary key is combined with a foreign, What it create...
What it creates while a primary key is combined with a foreign key? It creates Parent-Child relation ship between the tables that connect them while a primary key is combined w
Develop network database ipad app, I want an iPad app that is a simple 1 pa...
I want an iPad app that is a simple 1 page form to complete with text. The Objective is to allow a few dozen people of the same organization (they're all on iPad) to open the app,
Data envelopment analysis , I need a help with my assignment of data envelo...
I need a help with my assignment of data envelopment analysis which is due for submission next week on monday the 10th Dec. Will you be able to help so that I can submit it on tim
Need some database of usa and uk, I want Database Of United Kingdom with Cr...
I want Database Of United Kingdom with Criteria of:\r\n\r\n1). Name, Number, City, State, Postal Code, Address, Email id, DOB.\r\n\r\n2). Unsecure Debts only adds Credit Card Payme
Basics of relational models, In the first unit of this block, you have been...
In the first unit of this block, you have been given with the details of the Database Management System, its structure, advantages etc. This unit is an attempt to give you informat
In the architecture of a database system which external leve, In the archit...
In the architecture of a database system which external level used? In the architecture of a database system view external level used.
Attribute preservation, Attribute Preservation This is a easy and obvio...
Attribute Preservation This is a easy and obvious necessity that includes preserving all the attributes that were there in the relation that is being decomposed.
Accounting Assignment Help
Economics Assignment Help
Finance Assignment Help
Statistics Assignment Help
Physics Assignment Help
Chemistry Assignment Help
Math Assignment Help
Biology Assignment Help
English Assignment Help
Management Assignment Help
Engineering Assignment Help
Programming Assignment Help
Computer Science Assignment Help
Why Us ?
~24x7 hrs Support
~Quality of Work
~Time on Delivery
~Privacy of Work
Human Resource Management
Literature Review Writing Help
Follow Us |
T & C
Copyright by ExpertsMind IT Educational Pvt. Ltd.