What are dimensions?
Dimensions are categories by which summarized data can be viewed. E.g. a profit summary in a fact table can be viewed by a Time dimension, Region dimension, Product dimension
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
What are slowly changing dimensions ? 25.09.08
Dimensions that change over time are called Slowly Changing Dimensions. For instance, a product price changes over time; People change their names for some reas...What is degenerate dimension table? 24.09.08
Degenerate Dimensions : If a table contains the values, which r neither dimesion nor measures is called degenerate dimensions.Ex : invoice id,empno...Explain degenerated dimension in detail ? 22.09.08
A Degenerate dimension is a Dimension which has only a single attribute. This dimension is typically represented as a single field in a fact table. The da...What are the steps to build the datawarehouse 20.09.08
As far I know... Gathering bussiness requiremnts Identifying Sources Identifying Facts Defining Dimensions Define Attribues Redefine Dimensions & Attrib...What is conformed fact? 20.09.08
Conformed dimensions are the dimensions which can be used across multiple Data Marts in combination with multiple facts tables accordingly...What is degenerate dimension table? 18.09.08
Degenerate Dimensions : If a table contains the values, which r neither dimesion nor measures is called degenerate dimensions.Ex : invoice id,empno...Why aren’t my frames the exact size I specified? 11.09.08
Older versions of Netscape Navigator seems to convert pixel-based frame dimensions to whole percentages, and to use those percentage-based dimensions when layin...What are conformed dimensions? 17.03.06
Conformed dimensions mean the exact same thing with every possible fact table to which they are joined Ex:Date Dimensions is connected all facts like Sales fac...What are slowly changing dimensions? 17.03.06
SCD stands for Slowly changing dimensions. Slowly changing dimensions are of three types SCD1: only maintained updated values. Ex: a customer address modified...Differences between star and snowflake schemas? 17.03.06
Star schema - all dimensions will be linked directly with a fat table. Snow schema - dimensions maybe interlinked or may have one-to-many relationship with oth...