A data cube stores data in a summarized version which helps in a faster analysis of data. The data is stored in such a way that it allows reporting easily. E.g. using a data cube a user may want to analyze weekly, monthly performance of an employee. Here, month and week could be considered as the dimensions of the cube.
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?
Explain about analysis?
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
