Interested to Buy Any Domain ? << Click Here >> for more details...
What is an MDDB? What is the difference between MDDBs and
RDBMSs?
- 3 Answers
- 19587 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 |
what is the method of error handling when session is running?
Which one is better performance wise connected/un-connected lkp?why?
What is a grid in Informatica?
why dimenstion tables are denormalized in nature ?
How to enter same record twice in the target table,explain?
How to load last n records of file into target table - informatica
what is correlated query?
How do you load unique records into one target table and duplicate records into a different target table?
What are the settings that you use to configure the joiner transformation?
I want expect first and last record remaining all records will be loaded into target? which transformations we can use?
Source is a flat file and want to load unique and duplicate records separately into two separate targets; right??
What does refresh system mean, and what are its distinctive choice?
Teradata 
