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

Posted Date: 3/26/2013 2:28:53 PM | Location : USA

Ask an Expert

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

Write discussion on OLAP CUBES
Your posts are moderated

Write your message here..

Related Questions

Develop database academic assignment, Develop Database academic assignment ... Develop Database academic assignment Project Description: For a provided set of instructions in a case study design Entity Relationship Diagram. - Entity Relationship Diag

Create a database schema, Consider a database schema consisting of four rel... Consider a database schema consisting of four relations, whose schemas are: Product (maker, model, type) PC (model, speed, ram, hd, price) Laptop (model, speed, ram, hd, s

What is serialization and where it is used, What is serialization? Where it... What is serialization? Where it is used and why?  Serialization is a basic term used for mechanisms which enable objects and object structures to be converted into portable for

Relational algebra, Relational Algebra is a set of basic operations used to... Relational Algebra is a set of basic operations used to influence the data in relational model. These operations allow the user to specify basic retrieval request. The result of re

What is nested queries explain in details, What is Nested Queries explain i... What is Nested Queries explain in details? Nested Queries - A SELECT query could have subquery(s) in it. While a SELECT query having another SELECT query in it, is known as n

Explain about sql server 2000, What is the difference between SQL Server 2... What is the difference between SQL Server 2000 complete and differential backups? A complete backup makes a copy of the whole database. A differential backup creates a copy of

Give an example of enforcement in typing, Give an example of enforcement in... Give an example of enforcement in Typing. You can understand the idea of enforcement as it makes sure objects of dissimilar classes may not be interchanged as below:  Exampl

Relation and relational schema, A relation has: Relational Schema ... 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

Original Database, I need an ERD created for any original database(can be o... I need an ERD created for any original database(can be on anything). It needs to be 3NF. I then need all the CREATE STATEMENTS, INSERT STATEMENTS(anything you can think of as long

What are the objectives of advance object design, What are the Objectives o... What are the Objectives of Advance object design After this unit, you shall be able to: combine three OOAD models to obtain operations on the classes; develop algo