ALLInterview.com :: 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                      
Google
   
 
Categories >> Software >> Data Warehouse >> Data Warehouse General
 
 


 

 
 Teradata interview questions  Teradata Interview Questions (183)
 Business Objects interview questions  Business Objects Interview Questions (751)
 Cognos interview questions  Cognos Interview Questions (842)
 Informatica interview questions  Informatica Interview Questions (1622)
 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 (168)
 Data Stage interview questions  Data Stage Interview Questions (563)
 SAS interview questions  SAS Interview Questions (550)
 Micro Strategy interview questions  Micro Strategy Interview Questions (35)
 ETL interview questions  ETL Interview Questions (195)
 Data Warehouse General interview questions  Data Warehouse General Interview Questions (215)
Question
wht is degenerated dimension ?it's uses?
 Question Submitted By :: Data-Warehouse-General
I also faced this Question!!     Answer Posted By  
 
Answer
# 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 ?    59 Yes 4 No
Kranthi.kunta
 
Answer
# 2
degenerated dimension is data that is dimensional in nature
but stored in a fact table
 
Is This Answer Correct ?    27 Yes 7 No
Suba
 
 
 
Answer
# 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 ?    8 Yes 0 No
Santosh
 
Answer
# 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 ?    14 Yes 8 No
Krishna Murari
 
Answer
# 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 ?    7 Yes 4 No
Kvchowdary
 
Answer
# 6
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 ?    8 Yes 8 No
Nethaji
 
Answer
# 7
degenerated means a dimension key is add to facttable for
grouping the date transactionly but there is no table
 
Is This Answer Correct ?    5 Yes 5 No
Msb.dwh
 
Answer
# 8
degenerated dimension means with out having any source from
oltp system
 
Is This Answer Correct ?    3 Yes 9 No
Chandu
 
Answer
# 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 ?    4 Yes 15 No
Boss
 

 
 
 
Other Data Warehouse General Interview Questions
 
  Question Asked @ Answers
 
Which one among Star and snowflake schemas will occupy more space? Barclays 1
What is factless fact schema?   2
what is data validation strategies for data mart validation after loading process   1
What is DTM session?   1
suppose data are coming from different locations and those data will not change . is there any need to use surrogate key ? Oracle 3
5.Explain ODS ? HCL 3
What is a ETL/ How does Oracle support the ETL process?   1
Difference between Microstrategy and Hyperion if any one Knows kindly updated me my dear Friends   1
What's a Cube in Rolap? Oracle 2
Business rule implemntation depends on? 1.)ETL requiremnts 2.)ETL performance 3.)business requirements.   4
What is difference between Business Objects and Hyperion Essbase? Please help me Cap-Gemini 1
Give me a broad concept of what a data warehouse is, and what it might be used for?   2
 
For more Data Warehouse General Interview Questions Click Here 
 
 
 
 
 


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

ALLInterview.com   ::  KalAajKal.com