What is an MDDB? What is the difference between MDDBs and
RDBMSs?
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
How to call shell scripts from informatica?
Explain in detail scd type 2 through mapping.
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What is a shortcut and copy in Informatica and how two are different with each other?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What is decode in static cache?
what is the difference between informatica6.1 and infomatica7.1
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
How to generate sequence numbers using expression transformation?
What is expression transformation?
How to do the error handling of if ur source is flatfiles?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
Which version configuration tool used in ur project?
What is informatica etl tool?
Whats the difference between informatica powercenter server, repositoryserver and repository?