what role views play in dimensional modeling?
Answer / 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 |
What is a Data Cube?
Who needs data warehousing?
What is data stream and data adaopter?
How to handle time period attribute for time dependent data?? a.)add time period as a part of pk b.)add time period simply and make it nullablec.)add time period simply and make it not null.
what is the difference between aggregate table and fact table ? how do you load these two tables ?
What is the capacity of power cube?
What is ods (operation data source)?
Explain what are the various reporting tools in the market?
What are the vaious etl tools in the market?
Explain difference between snow flake and star schema.
What is difference between Mapplet and reusable transformation?
Explain how to get the first 100 rows from the flat file into the target?