Interested to Buy Any Domain ? << Click Here >> for more details...
What is an MDDB? What is the difference between MDDBs and
RDBMSs?
- 3 Answers
- 19585 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
what is song in infrmatica...?
What are the types of caches in lookup? Explain them.
What is an expression transformation in informatica?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
How can repository reports be accessed without sql or other transformations?
How to elaborate powercenter integration service?
What is parallel processing in informatica?
How many transformations can be used in mapplets.
Why update strategy and union transformations are active? Explain with examples.
What is a repository? And how to add it in an informatica client?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
Define sessions in informatica etl?
