Question1) Describe a job scheduling strategy which will meet business needs of reporting accessibility by 6am CST for the following cubes? Demonstrate the job scheduling dependencies in a pictorial form so that it is simple to understand.
i). Finance cube
ii). Warranty cube
iii). Order cube
iv). Customer master data
v). Vendor master data
vi). Product master data
vii). Other Master data
Finance and Order cubes cannot run together.
Question2) Above cubes are employed by EU and NA users, NA users will only employ NA data and EU users will employ only EU data however Master data is common for both NA and EU. The requirement of accessibility stays same for NA (6AM CST) and for EU reports or cubes must be accessible by 6am CET.
What changes you require to create to the job scheduling proposal of Question 1 to meet the need of Question 2?
CST – NA Central Standard Time
CET - EU Central European Time.