⟩ What is OLAP?
OLAP is an acronym for Online Analytical Processing. OLAP performs multidimensional analysis of business data and provides the capability for complex calculations, trend analysis, and sophisticated data modeling.
OLAP is an acronym for Online Analytical Processing. OLAP performs multidimensional analysis of business data and provides the capability for complex calculations, trend analysis, and sophisticated data modeling.
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])
Which of the following below is/are OLAP vendors? a) Cognos b) Infor c) Oracle corporation d) All of the above
Data that can be modeled as dimension attributes and measure attributes are called _______ data. a) Multidimensional b) Singledimensional c) Measured d) Dimensional
Explain about the database marketing application of OLAP?
Explain about multidimensional features present in OLAP?