What is an MDDB? What is the difference between MDDBs and
RDBMSs?
- 3 Answers
- 18619 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 if i will group by with some port in aggregator and will not pass the sorted values. Will the session fails tell in both cases ( if i have configured it for sorted input and if i have not configured it for sorted input).
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
Why we use lookup transformations?
what is the diff b/w union and joiner and lookup?
Which version configuration tool used in ur project?
What is power play plug in?
What are the steps involved in the migration from older version to newer version of Informatica Server?
there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation
CAN WE IMPLEMENT SCD TYPE 1 AND SCD TYPE 2 IN SAME MAPPING? IF SO HOW?
Why do we use DSS database for OLAP tools?
How to extract sap data using informatica? What is abap? What are idocs?
Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?
Teradata 
