punjabtechnicaluniversity.blogspot.in
Twisted Question :- Can you explain the star schema for OLAP ?
Twisted Question :- Can you explain the star schema for OLAP ?
The dimensions and measures are physically represented by a star schema.Dimension tables revolve around fact table. A fact table contains a column for each measure as well as a column for each dimension. Each dimension column has a foreign-key relationship to the related dimension table, and the dimension columns taken together are the key to the fact table.
0 comments:
Post a Comment
North India Campus