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
What are partition points?
Explain er diagram?
What is vdl (view definition language) explain?
Explain what is data validation strategies for data mart validation after loading process?
In microstrategy, how can we direct the sql generated to use a specifc table?
What is the difference between aggregate table and materialized view?
Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?
How can we do data cleaning?
What is data mart in data warehouse?
Whether dimension table can have numeric value?
What is latest version of power center / power mart?
What are components of report studio?
Why we use repository connectivity?
Explain the definition of normalized and denormalized view?
What is the use of incremental aggregation? Explain me in brief with an example?