Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

wht is degenerated dimension ?it's uses?

Answers were Sorted based on User's Feedback

wht is degenerated dimension ?it's uses?..

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

wht is degenerated dimension ?it's uses?..

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

wht is degenerated dimension ?it's uses?..

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

wht is degenerated dimension ?it's uses?..

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

wht is degenerated dimension ?it's uses?..

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

wht is degenerated dimension ?it's uses?..

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

wht is degenerated dimension ?it's uses?..

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

wht is degenerated dimension ?it's uses?..

Answer / nethaji

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

wht is degenerated dimension ?it's uses?..

Answer / chandu

degenerated dimension means with out having any source from
oltp system

Is This Answer Correct ?    6 Yes 14 No

wht is degenerated dimension ?it's uses?..

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

Post New Answer

More Data Warehouse General Interview Questions

What are the differences between star and snowflake schema?

0 Answers  

I need to set predefined condition. How I do this?

0 Answers  

What are the types of dimensional modeling?

0 Answers  

How many repositories can we create in Informatica?

14 Answers   Informatica,

Explain what type of indexing mechanism do we need to use for a typical datawarehouse?

0 Answers  

What is informatica architecture?

0 Answers  

What are the steps involved in creating dimensional modeling process?

0 Answers  

What is the metadata extension?

0 Answers  

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?

0 Answers  

What is metadata in context of a datawarehouse?

0 Answers  

For faster process, what we will do with the universe?

0 Answers  

Difference between cold fusion mx 6 and cold fusion mx 7?

0 Answers