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 how to export mappings to the production environment?
Explain the difference between filter and conditin?
What is the limit to the number of sources and targets you can have in a mapping?
Explain what is the extension of file to save template?
What are the advantages of query studio compared to report studio?
How do you create surrogate key using ab initio?
Define data warehouse?
What is called data cleaning?
Compare cold fusion with other programming languages?
What are the differences between datamart vs. Reporting cube?
What are aggregate transformation?
What is data validation strategies for data mart v?
Explain what are the vaious etl tools in the market?
What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?
Do you view contain data?
