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 what is the metadata extension?
What is pre-emptive and non-pre-emptive?
What are the advantages of cold fusion?
What are fact, dimension, and measure?
What is loop in data warehousing?
What is prompt types of prompts?use of prompts syntax of prompt?
What is a full backup?
Explain the difference between view and materialized view?
How can we determine what records to extract?
Define data warehouse?
What is the difference between ods and oltp?
After the generation of a report to whom we have to deploy or what we do after the completion of a report?
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani
How to stop a batch?
What is Active Datawarehousing?