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

Having clause-data manipulation language, Having clause This clause... Having clause This clause is used for producing conditions on grouped information. Example: Find maximum salary and department number of those departments where maxim

What are the different types of interfaces provided by dbms, Question 1 Su... Question 1 Suppose the employee employee id, name, designation, salary, attendance and address of any employee has to be stored in a database. You can store these data in a sequen

The tools that are available for managing mysql server, Describe the tools ... Describe the tools that are available for managing MySQL Server. Given below are the tools to manage MySQL server: mysqld - MySQL server daemon. This is used to begain t

Explain th process to avoid re-computation, Saving Derived Attributes to Av... Saving Derived Attributes to Avoid Re-computation Data that is derived from other data should be stored in the computed form to avoid re-computation. For this, we could define

Define average latency time, Define average latency time. The average l... Define average latency time. The average latency time of the disk is one-half the time for a full rotation of the disk.

What is database files , The database files accept the actual data and ... The database files accept the actual data and are typically the biggest in size. Depending on their shape, the tables for all the user operation can go in one database file-but

BMIS 351, Ask question #MinimRead Dennis et al. Chapter 6: Minicase 2. Work... Ask question #MinimRead Dennis et al. Chapter 6: Minicase 2. Work through it and answer the questions. See the attached example. SequenceDiagram.png Based on the structural mod

Transaction managenment, can you please explain with the help of suitable e... can you please explain with the help of suitable example the difference between conflict equivalence and conflict serializability?

Explain the steps for reduction of e-r model, Explain the steps for reducti... Explain the steps for reduction of E-R model into relational model. Ans:(a) Entity set in E-R model will be considered as table name in relational Model. (b) Attributes of e

What are the advantages of dbms, What are the advantages of DBMS ? 1. ... What are the advantages of DBMS ? 1. Centralized Management and Control - One of the major advantages of using a database system is in which the organization could exert, thr