Assign, Database Management System

#quesDefine 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
CST – NA Central Standard Time
CET - EU Central European Time.
tion..
Posted Date: 4/2/2013 12:07:31 PM | Location :







Related Discussions:- Assign, Assignment Help, Ask Question on Assign, Get Answer, Expert's Help, Assign Discussions

Write discussion on Assign
Your posts are moderated
Related Questions
Question: (a) One of the steps in the five-step problem-solving model is implementation. Implementation is considered a key step in the problem-solving model. A problem may be

Define Database layer? The database layer defines the data formats used in the database.

Increases efficiency : Data is stored close to most often used site, therefore retrieval would be faster. Also, data that is not required by local applications is not stored, there

Problem: (a) Briefly explain the ‘Hierarchical Database Model' using appropriate diagram. (b) List and briefly describe five potential benefits of the database approach comp

What is the difference between a HAVING CLAUSE and a WHERE CLAUSE? HAVING CLAUSE - HAVING CLAUSE is used only with SELECT statement. - It is normally used in a GROUP BY

A relation has: Relational Schema Relation instance Relational Schema: A relational schema shows the relation's name, its attributes and the domain of every a

What is a database? At any given time, they're storing a tremendous amount of information - inventory, in the case of Amazon, messages and interrelationships in the case of Tw

er diagtram for icici

Hi, Do you offer private tuition for DBMS?

Describe the different RAID levels.  Discuss the choices of the different RAID levels for different applications.          Ans:   There are several combinations of these approa