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 difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?
What function should we use to display the value entered or selected by a user in response to a prompt?
Explain if a flat file cotains 1000 records how can I get first and last records only?
How many project sources we can create in metadata?
What are the other names given to data warehousing?
Is there any difference in testing database and data ware housing?
What is partitioning? What are the types of partitioning?
I know of using applysimple, but there are other ways too?
What is core dimension?
How can you implement many relations in star schema model?
What is the limit to the number of sources and targets you can have in a mapping?
Explain what is the difference between a primary and secondary actor in use case modeling?
Explain what are the mapping paramaters and maping variables?
Explain what are the tasks that loadmanger process will do?
Explain what are the methodologies of data warehousing?
