wht is degenerated dimension ?it's uses?
Answer Posted / kranthi.kunta
Degenerate dimension: A column of the key section of the
fact table that does not have the associated dimension
table but used for reporting and analysis, such column is
called degenerate dimension or line item dimension.
For ex, we have a fact table with customer_id, product_id,
branch_id, employee_id, bill_no, date in key section and
price, quantity, amount in measure section. In this fact
table, bill_no from key section is a single value, it has
no associated dimension table. Instead of cteating a
seperate dimension table for that single value, we can
include it in fact table to improve performance.
SO here the column, bill_no is a degenerate dimension or
line item dimension.
Is This Answer Correct ? | 99 Yes | 6 No |
Post New Answer View All Answers
How many different schemas or dw models can be used in siebel analytics. I know only star and snow flake and any other model that can be used?
Explain the definition of normalized and denormalized view and what are the differences between them?
What is analytical or analytic mean?
How to performance tune reports?
What is the difference between mapping parameter & mapping variable in data warehousing?
What is Discrete and Continuous data in Data mining world?
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 when do we analyze the tables? How do we do it?
Can you state some of the innovations throughout history?
What are Non-additive facts?
What is called data cleaning?
Explain conformed fact?
Explain the difference between data ware house & data mart?
How can you communicate with web server (apache or iis) from coldfusion?
How to allow a dynamic selection of a column for a measure in a chart,without using variable?