Interested to Buy Any Domain ? << Click Here >> for more details...
What is an MDDB? What is the difference between MDDBs and
RDBMSs?
- 3 Answers
- 19903 Views
- I also Faced
- E-Mail Answers
Answer Posted / sri ram
MDDB stands for Multi Dimensional Database
MDDB: In MDDB, it views data in mutidimensional
(Perspective)i.e.,through various dimensions at a time with
the help of cubes developed using dimensions and stores
data in multidimensional i.e., stores data in power cubes.
In power cubes, each axis is a dimension and each member of
dimension is column.
In MDDB, at a glance we can see the dimensions and data
present in the dimensions
RDDB: In RDDB, it views data in two dimensional and stores
data in two dimensional i.e., in rows and columns in a
table .
In RDDB, we can just see the rows and columns, but only
after issuing select over that u can see the data.
Storage wise:
suppose I have 3 dimensions and 9 rows of data then
in MDDB: takes 9 cells to store the data
in RDDB: takes 27 cells to store the data
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
Explain incremental aggregation in informatica
What is an unconnected transformation?
Explain what is informatica metadata and where is it stored?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What is a rank transform?
What is the benefit of session partitioning?
How to create or import flat file definition in to the warehouse designer?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What are the different types of olap? Give an example?
what is informatica metadata?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What is lookup transformation?
Explain sessions. Explain how batches are used to combine executions?
