What is Rollup and cube?
Submitted by: AdministratorCustom 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.
Submitted by: Administrator
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.
Submitted by: Administrator
Read Online MS SQL Data Mining Job Interview Questions And Answers
Top MS SQL Data Mining Questions
☺ | Explain what are different stages of “Data mining”? |
☺ | Explain what is Discrete and Continuous data in Data mining world? |
☺ | Can you explain what is MODEL in Data mining world? |
☺ | Tell me what are CUBES? |
☺ | Do you know how does the data mining and data warehousing work together? |
Top New MS SQL Server Categories
☺ | SQL Server Database Administrator Interview Questions. |
☺ | SQL Server Service Broker Interview Questions. |
☺ | SQL Server Locks Interview Questions. |
☺ | SQL Server Constraints Interview Questions. |
☺ | MS SQL Data Mining Interview Questions. |