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

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

Write discussion on datawarehouse
Your posts are moderated
Related Questions
A step-wise distributed database design methodology Following is a step-wise methodology for distributed database design. (1) Examine the nature of distribution. Find out wh

What is the most significant feature that does not directly map into programming language structures? Why? Association, since there are complex types of association, like as qu

Saving Derived Attributes to Avoid Re-computation   As discussed, "redundancy means duplication of exact data". But, if multiple copies of same data are present in the system,

Economics: It is now usually accepted that it costs less to make a system of smaller computers with the equivalent power of a one large computer. It is more cost-effective to get s

State about the Activity Diagram Activity diagrams show flow from one activity to other. It is an ongoing non atomic execution within a state machine. Activity finally results

What is Specialization? Specialization: Specialization permits you to describe new types of information (new structural types or latest domains of information), although reusin

what is RDBMS? how it works? good example.

Explain Thomas' Write rule.  Show how it is different from timestamp ordering protol Ans: In timestamp-based concurrency control the thomas Write rule is a rule. Given a Timest

What is a heterogeneous distributed database? In a heterogeneous distributed database, dissimilar sites may use different schemas, and dissimilar dbms s/w. The sites may not be