:: Home Page            
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Categories >> Software >> Data Warehouse >> Data Warehouse General


 Teradata interview questions  Teradata Interview Questions (184)
 Business Objects interview questions  Business Objects Interview Questions (756)
 Cognos interview questions  Cognos Interview Questions (853)
 Informatica interview questions  Informatica Interview Questions (1626)
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions (29)
 Actuate interview questions  Actuate Interview Questions (35)
 Ab Initio interview questions  Ab Initio Interview Questions (172)
 Data Stage interview questions  Data Stage Interview Questions (565)
 SAS interview questions  SAS Interview Questions (561)
 Micro Strategy interview questions  Micro Strategy Interview Questions (37)
 ETL interview questions  ETL Interview Questions (196)
 Data Warehouse General interview questions  Data Warehouse General Interview Questions (216)
wht is degenerated dimension ?it's uses?
 Question Submitted By :: Data-Warehouse-General
I also faced this Question!!     Answer Posted By  
# 1
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 ?    65 Yes 4 No
# 2
degenerated dimension is data that is dimensional in nature
but stored in a fact table
Is This Answer Correct ?    28 Yes 8 No
# 3
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 ?    10 Yes 0 No
# 4
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 ?    15 Yes 8 No
Krishna Murari
# 5
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 ?    8 Yes 5 No
# 6
degenerated means a dimension key is add to facttable for
grouping the date transactionly but there is no table
Is This Answer Correct ?    7 Yes 5 No
# 7
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 ?    9 Yes 9 No
# 8
degenerated dimension means with out having any source from
oltp system
Is This Answer Correct ?    4 Yes 9 No
# 9
A fact table some time act as a dimention and shared with
one or more fact tables in this schema
Is This Answer Correct ?    5 Yes 15 No

Other Data Warehouse General Interview Questions
  Question Asked @ Answers
What is Grain & Granularity in Data Warehouse. TCS 2
What is Molap and Rolap? What is Diff between Them?   10
What is a star schema? Why does one design this way?   3
What is the difference between a W/H and an OLTP application?   5
What is mapplet?   1
What is Time Series algorithm in data mining?   2
What is DTS ?   1
What is META DATA information in Data warehousing projects? IBM 2
how can one connect two fact tables ? is it possible ? how? ABC 8
What is difference between a connected look up and unconnected look up?   1
what is hybrid schema TCS 4
For more Data Warehouse General Interview Questions Click Here 

Copyright Policy  |  Terms of Service  |  Articles  |  Site Map  |  RSS Site Map  |  Contact Us
Copyright 2013  All Rights Reserved.   ::