What is an MDDB? What is the difference between MDDBs and
RDBMSs?
Answer Posted / 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 |
Post New Answer View All Answers
What is the benefit of partitioning a session?
Why update strategy and union transformations are active?
How can we use mapping variables in informatica?
What is rank index in rank transformation?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
Why union transformation is an active transformation?
if we have a delimiters at unwanted places in a flat file how can we over come those.
How can you define user defied event?
can we override a native sql query within informatica? Where do we do it?
What is workflow? What are the components of the workflow manager?
What is informatica worklet?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What are the different lookup cache(s)?
wat are deployement groups in informatica, how it will be used for developers
How to use procedural logic inside infromatica?