Answer Posted / pratap gangula
A confirmed dimension is a dimension which can be joined with more than one fact table and can be reused in other data marts as well.
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Why we use repository connectivity?
What is the difference between metadata and data dictionary?
What are the steps involved in designing a fact table?
Explain when do we analyze the tables? How do we do it?
Compare aggregates and data marts
Explain what are the different methods of loading dimension tables?
What is the difference between power center and power mart?
What is the use of tabular model, tabular sql, tabular reference in real time application?
What is a source qualifier?
What is a fact, dimension, measure?
What are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?
What is the difference between olap and oltp?
What is vldb(very large databases)?
Fact table is in normalized or de-normalized form?
Explain why dimenstion tables are denormalized in nature?