wht is degenerated dimension ?it's uses?
- 10 Answers
- 48812 Views
- CTS, Infosys, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / suba
degenerated dimension is data that is dimensional in nature
but stored in a fact table
| Is This Answer Correct ? | 40 Yes | 9 No |
Answer / 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 |
Answer / krishna murari
These are some date elements in the operational system
which are neither fact nor strictly dimension attributes.
These are useful for some kind of analysis.
These are kepts as attributes in fact table called
degenerated dimension
| Is This Answer Correct ? | 21 Yes | 12 No |
Answer / kvchowdary
degenerate dimension is a data dimension that is stored in
the fact table rather than a separate dimension table. This
eliminates the need to join to a dimension table. You can
use the data in the degenerate dimension to limit or 'slice
and dice' your fact table measure
| Is This Answer Correct ? | 13 Yes | 7 No |
Answer / takhatraj singh chouhan
Degenerated Dimension is a dimension key without corresponding dimension. Example:
In the PointOfSale Transaction Fact table, we have:
Date Key (FK), Product Key (FK), Store Key (FK), Promotion Key (FP), and POS Transaction Number
Date Dimension corresponds to Date Key, Production Dimension corresponds to Production Key. In a traditional parent-child database, POS Transactional Number would be the key to the transaction header record that contains all the info valid for the transaction as a whole, such as the transaction date and store identifier. But in this dimensional model, we have already extracted this info into other dimension. Therefore, POS Transaction Number looks like a dimension key in the fact table but does not have the corresponding dimension table.
Therefore, POS Transaction Number is a degenerated dimension.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / msb.dwh
degenerated means a dimension key is add to facttable for
grouping the date transactionly but there is no table
| Is This Answer Correct ? | 9 Yes | 6 No |
When a Fact table has dimension value stored it is called
degenerated dimension.Since a fact table doesn't store
textual items ,it should be stored in varchar datatype.
Why we are going?
Instead of maintaining a separate dimension table with
single values ,for eg.customer_policy_details='paid' ,we
can store it in fact table ,for performance.
| Is This Answer Correct ? | 12 Yes | 15 No |
Answer / chandu
degenerated dimension means with out having any source from
oltp system
| Is This Answer Correct ? | 6 Yes | 14 No |
Answer / boss
A fact table some time act as a dimention and shared with
one or more fact tables in this schema
| Is This Answer Correct ? | 7 Yes | 20 No |
Explain how does tuple-oriented relational calculus differ from domain-oriented relational calculus?
Explain what is the difference between stop and abort?
What is data warehouse architecture?
What are partition points?
What is factless fact schema?
Which component has onread method and what it is used for?
How can we import and export using BCP utility?
What are Non-additive facts?
What is source qualifier?
What is data stream and data adaopter. Is it same are different? Explain?
Explain the definition of normalized and denormalized view and what are the differences between them?
How to handle time period attribute for time dependent data?? a.)add time period as a part of pk b.)add time period simply and make it nullablec.)add time period simply and make it not null.
Teradata 
