Interested to Buy Any Domain ? << Click Here >> for more details...
What's a Cube in Rolap?
- 2 Answers
- 11791 Views
- Oracle, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / swati
ROLAP Cube is a datastructure that is used for faster analysis of data.ROLAP is slow at analysis but large at capacity(Multibillion rows can b stored) u can use good indexes to improve its performance
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / fatma
ROLAP Cubes: stands for Relational OLAP. In ROLAP cubes a
copy of data from the fact table is not made and the data
aggregates are stored in tables in the source relational
database. A ROLAP cube is best when there is limited space
on the Analysis Server and query performance is not very
important. ROLAP local cubes contain the dimensions and
cube definitions but aggregates are calculated when they
are needed. ROLAP cubes require less storage space than
MOLAP and HOLAP cubes.
| Is This Answer Correct ? | 4 Yes | 1 No |
What is the difference between junk dimension and degenerated dimension?
Explain the data type of the surrogate key?
Explain Process flow in data warehouse??
If I have table T1 and table T2 T1 has 250 cols and 10,000 rows T2 has 2 billion rows and 10 cols Which one would be Fact table and which one would be Dimension table and why ?
3 Answers Extech, Principal Finance,
Which technology should be used for interactive data querying across multiple dimensions for a decision making for a dw?
Explain about core dimension, balanced dimension, and dirty dimension?
Explain what are the modules in power mart?
What Oracle features can be used to optimize my Warehouse system?
What are steps we have to follow in designing the userfriendly universe?
Which kind of index is preferred in DWH?
Explain me what are conformed dimensions?
What are the methodologies of data warehousing?
Teradata 
