wht is degenerated dimension ?it's uses?
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 ?||97 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
|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 / 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|
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 ?||3 Yes||0 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
|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|
What are the differences between star and snowflake schema?
I need to set predefined condition. How I do this?
What are the types of dimensional modeling?
How many repositories can we create in Informatica?
Explain what type of indexing mechanism do we need to use for a typical datawarehouse?
What is informatica architecture?
What are the steps involved in creating dimensional modeling process?
What is the metadata extension?
In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?
What is metadata in context of a datawarehouse?
For faster process, what we will do with the universe?
Difference between cold fusion mx 6 and cold fusion mx 7?