Interested to Buy Any Domain ? << Click Here >> for more details...
wht is degenerated dimension ?it's uses?
- 10 Answers
- 51702 Views
- CTS, Infosys, I also Faced
- E-Mail Answers
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
What is a view as it relates to system modeling?
How to allow a dynamic selection of a column for a measure in a chart,without using variable?
How are models actually derived?
What is the very basic difference between data warehouse and operational databases?
What is execution plan?
What is meant by metadata in context of a data warehouse?
What are diagrams?
How to add a number to a macro variable?
How to generate iqd file from framework manager?
What are steps we have to follow in designing the userfriendly universe?
What is Star Schema?
What is difference macros and prompts?
"A dimension table is wide but the fact table is deep," explain the statement in your own words.
Explain why dimenstion tables are denormalized in nature?
In document how to create metrics?
