Interested to Buy Any Domain ? << Click Here >> for more details...
What is an MDDB? What is the difference between MDDBs and
RDBMSs?
- 3 Answers
- 19912 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / lok
in mddb we can analyze the data in multiple ways,here we
can create power cubes.
but in rdbm we can create cross tab reports,simple list
reports.
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / 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 |
Answer / pradeeshkumar
RDBMS-Relational database management systems.
It involves managing the information that are stored in
relational tables(tables that are related with each other
using a primary and foreign key relationship).
It's not multidimensional. Its just information stored in
tables.
MDDB- Multidimensional Database comes into play at the time
of OnLine Analytical Processing. It stores information
along multidimensions(mostly in multi-d cubes) that
facilitates slicing and dicing.
| Is This Answer Correct ? | 3 Yes | 2 No |
how will compare two mappings in two different repository?
How can we integrate different flat file data in a single mapping and with in a single execution
my session have to run Monday to Saturday not run sunday how to sedule in informatica level?
1 Answers Infinite Computer Solutions,
Under what conditions selecting sorted input in aggregator will still not boost session performance?
By seeing the parameter file how do u identify wheather it is a workflow parameter or mapping parameter?
What are the conditions needed to improve the performance of informatica aggregator transformation?
What are roles and groups and benefits of using them?
who is the best faculty for informatica in hyderabad ameerpet?
One flatefile it contains some data but i want to dont want to load first and last record ..how it is? can u tell me complete logic?
How to create the source and target database connections in server manager?
COM components can be used in Informatica
hw cn v elimate dublicate values from lookup without overriding sql?
Teradata 
