Hyper cube or multidimensional cube forms the core of OLAP system. This consists of measures which are arranged according to dimensions. Hyper cube Meta data is created by star or snow flake schema of tables in RDBMS. Dimensions are extracted from dimension table and measures from the fact table.
Explain about OLAP?
What is sparsity? a) A condition when each cell of the cube is filled with data and that leads to more processing time. b) A condition when each cell of the cube is not filled with data and that leads to less processing time. c) A condition when each cell of the cube is not filled with data and that leads to more processing time. d) A condition when each cell of the cube is not filled with data.
What is the other name for OLAP cube? a) Multidimensional cube b) Hyper cube c) Cube d) Both 1 and 2
What is OLAP?
What are Cubes in OLAP?
What are Database roles in OLAP?
Select item name, color, clothes size, sum(quantity) from sales group by rollup(item name, color, clothes size); How many grouping is possible in this rollup? a) 8 b) 4 c) 2 d) 1
Where is Data Sources in OLAP?
What are Fact Tables?
Which one of the following is the right syntax for DECODE ? a) DECODE (search, expression, result [, search, result]… [, default]) b) DECODE (expression, result [, search, result]… [, default], search) c) DECODE (search, result [, search, result]… [, default], expression) d) DECODE (expression, search, result [, search, result]… [, default])
rendc.org
Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."
Get all the latest information on rendc.org
© 2022 | All rights reserved.
RENDC
welcome to www.rendc.org
