Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
What are components of reportnet?
if you use oracle sql*loader , how do you transform data with it during loading?
Explain difference between data ware house & data mart?
Explain what are the mapping paramaters and maping variables?
What is a fact, dimension, measure?
Explain can a dimension table contains numeric values?
What is informatica architecture?
What is the limit to the number of sources and targets you can have in a mapping?
Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can I do it and drag it onto report editor?
what is the synchonus? wht is the diff between synchronous and asynchronous what is the diff between v1 and v2 v3 delta modes in sap ecc
What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?
What is the difference between filter and lookup transformation?
In a star schema, are foreign key constraints between facts and dimensions neccessary?
How to eliminate duplicate rows from flat file?
Explain what is fact less fact table? Where you have used it in your project?
