Hi,
2 separate measure groups of a cube are being processed with 2 separate SSIS packages and these measure groups use same dimensions of the cube. SSIS packages are used to handle the partitions. Would there be a conflict if the SSIS packages both attempt to Process the same dimensions (update/full process) at the same time?
How does Analysis Services 2005 handle this? Does one wait for the other and then the 2nd package skips the Dim process or reprocesses it?
In such cases, is there a need to have a SSIS package that processes only the dimensions 1st and then the other 2 packages start off parallely to process the 2 measure groups without touching the dims.
Regards
You can process the dimension first in one step and after this processing have succeded you can process the two measure groups partitions in parallell.
Your last alternative sounds correct.
Regards
Thomas Ivarsson.
No comments:
Post a Comment