I have a cube and it is processed every 6 hours. 3 different process calls the SSIS package through SQL Server Agent to process the cube, and they all may call the SSIS package
at the same time. But for that I set an Indicator which tells the cube is processing and it waits for a minute and re-checks it and then processes the cube.
My problem here is while the cube is processing other ETL jobs might update/delete/insert the data into Fact Tables. What will happen when cuube is processing and these things are
done simulatneously. Can anyone explain what will be the possible outcome.
View Complete Post