Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / aravalli rajasekhar
There are many types of dimensions
conformed dimesion:
the dimension which are maintain the relation ship between
two are more fact table are called conformed dimension.
eg: galaxy schema
shrunk dimesion:
the dimnesion which does not maintain the direct relation to
fact table is called shrunk dimesion
junk dimesion:
the dimesion which are maintain the relation ship low
coradinality values is called junk dimension
eg: the dimsion apply on dimesion gender
rolepaly dimesion:
the dimesion which are occred more than two dimension tables
are called rolepaly dimension
eg: time appear frequently all dimension tabsles
dirt dimesoion:
the dimesion which are already occred in the fact table
but again apper with version change those dimension are
called dirty dimesion
eg: SCD2
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain what is type 2 version dimension?
What is a fact, dimension, measure?
What is the function of etl when used in data warehousing?
Which technology should be used for interactive data querying across multiple dimensions for a decision making for a dw?
What is the difference between agglomerative and divisive hierarchical clustering?
Explain what are the steps to build the data warehouse?
Explain what is a cube in data warehousing concept?
What are the differences between star and snowflake schema?
What is the use of tabular model, tabular sql, tabular reference in real time application?
Explain can a dimension table contains numeric values?
How do you define data block size?
What are the fundamental elements of the data warehouse?
What is the function of surrogate key in data warehousing?
Explain what is a three tier data warehouse?
Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?
