what role views play in dimensional modeling?
Answer Posted / kashish
A dimensional data model (DDM) represents business metrics
as data structures. This is a form of E-R modeling that is
limited to working with "measurement" types of subjects and
has a prescribed set of allowable structures.
| Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
How to limit the max no of rows retrieved in the report?
Explain what are non-additive facts in detail?
What is the difference between view materialized view and view?
What are the other names given to data warehousing?
For faster process, what we will do with the universe?
Explain why are oltp database designs not generally a good idea for a data warehouse?
What are the various methods of getting incremental records or delta records from the source systems?
Explain what are the basic needs to join two sources in a source qualifier?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in
What are loops in Datawarehousing?
In document how to create metrics?
What is a junk dimension? What is the difference between junk dimension and degenerated dimension?
What are the differences between datamart vs. Reporting cube?
How to import vsam files from source to target. Do we need a special plugin?
What is the difference between snowflake and star schema?