Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

wht is degenerated dimension ?it's uses?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between agglomerative and divisive hierarchical clustering?

1191


What are the steps involved in designing a fact table?

894


Is there any difference in testing database and data ware housing?

2768


What is data warehouse architecture?

1054


Explain what are the vaious etl tools in the market?

944


Explain what is batch and describe about types of batches?

1081


how can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause

2142


Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.

907


What is Active Datawarehousing?

1023


How do you create surrogate key using ab initio?

1000


What is the difference between olap and datawarehosue?

961


What does level of granularity of a fact table signify?

1097


Can we start and stop single session in concurent bstch?

948


What is your spectra photometer working principles?

986


Explain what is the limit to the number of sources and targets you can have in a mapping?

1005