MS SQL Data Mining Question:
Download Job Interview Questions and Answers PDF
What is Rollup and cube?
Answer:
Custom rollup operators provide a simple way of controlling the process of rolling up a member to its parents values.The rollup uses the contents of the column as custom rollup operator for each member and is used to evaluate the value of the member’s parents.
If a cube has multiple custom rollup formulas and custom rollup members, then the formulas are resolved in the order in which the dimensions have been added to the cube.
If a cube has multiple custom rollup formulas and custom rollup members, then the formulas are resolved in the order in which the dimensions have been added to the cube.
Download SQL Server Data Mining Interview Questions And Answers
PDF
Previous Question | Next Question |
Tell me what are CUBES? | Do you know what are OLAP and OLTP? |