What is an MDDB? What is the difference between MDDBs and
RDBMSs?
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 |
Explain how many types of dimensions are available in informatica?
in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in target i want id value ---- ------ 1 a,d,f 2 b,e 3 f How to implement it in informatica without using normalizer transformation?
explan ur project architecture?
What is meant by target load plan?
1:when we develop a project what are the performance issue will raise?? KPIT 2:if a table have INDEX and CONSTRAINT why it raise the performance issue bcoz when we drop the index and disable the constraint it performed better??KPIT 3:what are unix commands frequently used in informatica??
What is the term PIPELINE in informatica ?
Hi gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance....
My source has 100 records. I have targets say in number 5. all target tables has parent and child relationships in between themselves. Now I want to load all 100 records into all targets. How U can ensure that record inserted in parent and then loaded into child.
1.what is SDLC of a project,explain in detail? 2.what are dimensions,facts?what is confirmed dimensions? 3.what is the need of OLTP? when we have datawarehousing?
my source is junk data how will u remove that junk data by using unix please any one replay me
how many ways can we implement SCD2?
what is meant by data driven.. in which scenario we use that..?