wht is degenerated dimension ?it's uses?
Answer Posted / santosh
According to Ralph Kimbal, in a data warehouse, a degenerate dimension is a dimension which is derived from the fact table and doesn't have its own dimension table. Degenerate dimensions are often used when a fact table's grain represents transactional level data and one wishes to maintain system specific identifiers such as order numbers, invoice numbers and the like without forcing their inclusion in their own dimension. The decision to use degenerate dimensions is often based on the desire to provide a direct reference back to a transactional system without the overhead of maintaining a separate dimension table.
Is This Answer Correct ? | 20 Yes | 1 No |
Post New Answer View All Answers
Explain the differences between normalizer and normalizer transformation?
What a static and local variable?
How can you communicate with web server (apache or iis) from coldfusion?
What are parallel querys and query hints?
Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?
Explain what are the advantages and disadvantages of reporting directly against the database?
What are the different ways to represent the loading of dimension tables?
How to calculate fact table granularity?
What is the extension of file to save template?
What are the various methods of getting incremental records or delta records from the source systems?
What is drill-through?
Suppose date is 05sep2005; I want the output like 05sep2005:00:00:00 ; how it will come?
What are partition points?
What is a source qualifier?
What are the differences between star and snowflake schema?