Degenerate dimension

According to Ralph Kimball,[1] in a data warehouse, a degenerate dimension is a dimension key (primary key for a dimension table) in the fact table that does not have its own dimension table, because all the interesting attributes have been placed in analytic dimensions. The term "degenerate dimension" was originated by Ralph Kimball.

As Bob Becker says:

Degenerate dimensions commonly occur when the fact table's grain is a single transaction (or transaction line). Transaction control header numbers assigned by the operational business process are typically degenerate dimensions, such as order, ticket, credit card transaction, or check numbers. These degenerate dimensions are natural keys of the "parents" of the line items.
Even though there is no corresponding dimension table of attributes, degenerate dimensions can be quite useful for grouping together related fact tables rows. For example, retail point-of-sale transaction numbers tie all the individual items purchased together into a single market basket. In health care, degenerate dimensions can group the claims items related to a single hospital stay or episode of care.[2]

Other uses of the term

Although most writers and practitioners use the term degenerate dimension correctly, it is very easy to find misleading definitions in online and printed sources. For example, the Oracle FAQ defines a degenerate dimension as 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 measures."[3]

This common interpretation implies that it is good dimensional modeling practice to place dimension attributes in the fact table, as long as you call them a degenerate dimension. This is not the case; the concept of degenerate dimension was developed by Kimball to support a specific, well-defined exception to the otherwise ironclad rule that dimension attributes are always pulled out into dimension tables.

See also

Notes

  1. ^ Kimball, Ralph; Ross, Margy (2002). The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling (Second ed.). Indianapolis, IN: John Wiley & Sons. pp. 50, 398. ISBN 978-0-471-20024-6.
  2. ^ Becker, Bob (3 June 2003). "Design Tip #46: Another Look at Degenerate Dimensions". Fact Table Core Concepts. Kimball Group. Retrieved 25 January 2013.
  3. ^ "Degenerate dimension". Oracle FAQ's. Retrieved 31 July 2011.

Bibliography

Read other articles:

Estriol sulfate

Estriol sulfate Names IUPAC name 16α,17β-Dihydroxyestra-1,3,5(10)-trien-3-yl hydrogen sulfate Systematic IUPAC name (1R,2R,3aS,3bR,9bS,11aS)-1,2-Dihydroxy-11a-methyl-2,3,3a,3b,4,5,9b,10,11,11a-decahydro-1H-cyclopenta[a]phenanthren-7-yl hydrogen sulfate Other names Estriol 3-sulfate; Estra-1,3,5(10)-triene-3,16α,17β-triol 3-sulfate Identifiers CAS Number 481-95-8 Y 3D model (JSmol) Interactive image ChEMBL ChEMBL2074797 ChemSpider 59789 PubChem CID 66415 UNII LZ7JHK6R2A Y CompTo...

 

Бортовой номер

Эта статья о способе обозначения кораблей. О способе обозначения самолётов — смотрите статью Регистрация воздушных судов Эта статья о понятии «бортовой номер» в западных флотах. О понятии Бортовой номер в СССР и России — см. статью Тактический номер Эсминец The Sullivans (�...

 

Dino Risi

Dino RisiRisi di Festival Film Cannes 1993.Lahir(1916-12-23)23 Desember 1916Milan, ItaliaMeninggal7 Juni 2008(2008-06-07) (umur 91)Roma, ItaliaTahun aktif1946–2002 Dino Risi (23 Desember 1916 – 7 Juni 2008) adalah seorang sutradara Italia. Bersama dengan Mario Monicelli, Luigi Comencini, Nanni Loy dan Ettore Scola, ia menjadi salah satu master dari Commedia all'italiana. Ia lahir di Milan. Ia memiliki dua saudara, satu kakak Fernando Risi (1890-?) seorang sinematografer dan sat...

Don Arden

English music manager and agent (1926–2007) This article is about the entertainment manager. For the Vegas choreographer, see Donn Arden. This article needs additional citations for verification. Please help improve this article by adding citations to reliable sources. Unsourced material may be challenged and removed.Find sources: Don Arden – news · newspapers · books · scholar · JSTOR (December 2021) (Learn how and when to remove this template messa...

 

Ruffré

Cet article est une ébauche concernant une localité italienne et le Trentin-Haut-Adige. Vous pouvez partager vos connaissances en l’améliorant (comment ?) selon les recommandations des projets correspondants. Ruffrè Administration Pays Italie Région Trentin-Haut-Adige  Province Trentin   Code postal 38010 Code ISTAT 022162 Code cadastral H634 Préfixe tel. 0463 Démographie Gentilé ruffredani Population 420 hab. (1er janvier 2023[1]) Densité 70 hab./km2 Géo...

 

East Aleppo offensive (2017)

Syrian military operation in January–April 2017 For the previous offensive, see East Aleppo offensive (2015–16). For the later offensive, see Maskanah Plains offensive. East Aleppo offensive (2017)Part of the Syrian civil war, the Turkish involvement in the Syrian Civil War, and the Russian military intervention in SyriaMap of the wider campaigns in northern Aleppo as of 11 March 2017  Syrian Armed Forces and allied groups  Syrian Democratic Forces  Islamic S...

コルク

この記事は検証可能な参考文献や出典が全く示されていないか、不十分です。出典を追加して記事の信頼性向上にご協力ください。（このテンプレートの使い方）出典検索?: コルク – ニュース · 書籍 · スカラー · CiNii · J-STAGE · NDL · dlib.jp · ジャパンサーチ · TWL（2017年4月） コルクを打ち抜いて作った瓶の栓 コルク（木栓、�...

 

QFU

Questa voce sull'argomento storia e cultura dell'aviazione è solo un abbozzo. Contribuisci a migliorarla secondo le convenzioni di Wikipedia. Il QFU, uno dei codici Q, rappresenta l'orientamento magnetico di una pista di volo. La nomenclatura è del tipo x/y dove x varia da 0 a 18 e y differisce da x di 18. x indica la decina di gradi a partire da nord girando in senso orario, y indica l'orientamento della pista nel verso opposto (18x10=180°). Ad esempio una pista 04/22 ha orientament...

 

Stadion MAC³PARK

Stadion MAC³PARK Informasi stadionNama lamaStadion FC Zwolle (2007–2012)Stadion IJsseldelta (2012–2016)OperatorStadion Ontwikkeling ZwolleLokasiLokasiStadionplein 18025 CP Zwolle BelandaKoordinat52°31′2.25″N 6°7′18.88″E / 52.5172917°N 6.1219111°E / 52.5172917; 6.1219111Koordinat: 52°31′2.25″N 6°7′18.88″E / 52.5172917°N 6.1219111°E / 52.5172917; 6.1219111KonstruksiMulai pembangunan9 Maret 2007Dibuka29 Agustus 200...

2013 World Championships in Athletics – Women's pole vault

Women's pole vault at the 2013 World ChampionshipsVenueLuzhniki StadiumDates11 August (qualification)13 August (final)Competitors22 from 13 nationsWinning height4.89 m (16 ft 1⁄2 in)Medalists  Yelena Isinbayeva Russia (RUS) Jenn Suhr United States (USA) Yarisley Silva Cuba (CUB)← 20112015 → Official Video Events at the2013 World ChampionshipsTrack events100 mmenwomen200 mmenwomen400 mm...

 

Dimethylallyl pyrophosphate

Dimethylallyl pyrophosphate Names IUPAC name 3-Methyl-2-buten-1-yl trihydrogen diphosphate Other names Dimethylallyl diphosphate; isoprenyl pyrophosphate; isoprenyl diphosphate Identifiers CAS Number 358-72-5 Y 3D model (JSmol) Interactive image ChemSpider 627 Y MeSH 3,3-dimethylallyl+pyrophosphate PubChem CID 647 CompTox Dashboard (EPA) DTXSID70189331 InChI InChI=1S/C5H12O7P2/c1-5(2)3-4-11-14(9,10)12-13(6,7)8/h3H,4H2,1-2H3,(H,9,10)(H2,6,7,8)Key: CBIDRCWHNCKSTO-UHFFFAOYSA-N SM...

 

301-й военный госпиталь НОАК

301-й военный госпиталь НАОК Расположение Пекин, 4-я кольцевая автодорога Подчинение Народно-освободительная армия Китая, Управление логистики Центрального военного совета КНР[англ.] Форма военный госпиталь Профиль многопрофильное Дата основания 1953 Характеристики Изве�...

José Luis Sierra Pando

José Luis Sierra José Luis Sierra, como entrenador de Colo-Colo en 2016Datos personalesNombre completo José Luis Sierra PandoApodo(s) CotoNacimiento Santiago5 de diciembre de 1968 (55 años)Altura 1,81 m (5′ 11″)Pareja Grace CabreraCarrera como entrenadorDeporte FútbolDebut como entrenador 2009(Unión Española)Carrera como jugadorPosición MediocampistaDebut como jugador 1989(Unión Española)Retirada deportiva 2009(Unión Española)Part. 53 (selección) TrayectoriaEntrenad...

 

العلاقات الدنماركية الباربادوسية

العلاقات الدنماركية الباربادوسية الدنمارك باربادوس   الدنمارك   باربادوس تعديل مصدري - تعديل   العلاقات الدنماركية الباربادوسية هي العلاقات الثنائية التي تجمع بين الدنمارك وباربادوس.[1][2][3][4][5] مقارنة بين البلدين هذه مقارنة عامة ومرجعية �...

 

Francesco Durante

Disambiguazione – Se stai cercando altri significati, vedi Francesco Durante (disambigua). Francesco Durante Francesco Durante (Frattamaggiore, 31 marzo 1684 – Napoli, 30 settembre 1755) è stato un compositore italiano. Indice 1 Biografia 2 Opere 2.1 Media 2.2 La musica 2.2.1 Composizioni vocali 2.2.2 Cantate, duetti, arie 2.2.3 Oratori 2.2.4 Musica strumentale 2.3 Musica sacra 2.3.1 Messe 2.3.2 Mottetti 2.3.3 Antifone, sequenze, inni 2.3.4 Spezzoni di Messe 2.3.5 Requiem 2.3.6 Magnific...

مونتبريزون (فرنسا)

Montbrison  شعار الاسم الرسمي (بالفرنسية: Montbrison)‏    الإحداثيات 45°36′30″N 4°03′57″E / 45.6083°N 4.0658°E / 45.6083; 4.0658 تقسيم إداري  البلد فرنسا[1][2]  التقسيم الأعلى لوار  عاصمة لـ لوار (1795–1855)  خصائص جغرافية  المساحة 16.33 كيلومتر مربع[3]  ارتفاع 399 م�...

 

New Jalpaiguri–New Bongaigaon section

Railway line in India New Jalpaiguri–New Bongaigaon Section (including Fakiragram-Dhubri branch line)New Bongaigaon Junction, an important railway station on New Jalpaiguri–New Bongaigaon sectionOverviewStatusOperationalOwnerIndian RailwaysLocaleWest Bengal, AssamTerminiNew JalpaiguriNew BongaigaonStations31ServiceOperator(s)Northeast Frontier RailwayHistoryOpened1963TechnicalLine length252 km (157 mi)Track gauge5 ft 6 in (1,676 mm) broad gaugeElectrification...

 

Sacrosanctum Concilium

Catholic Constitution on the Liturgy Part of a series on theCanon law of theCatholic Church Ius vigens (current law) 1983 Code of Canon Law Omnium in mentem Magnum principium Code of Canons of the Eastern Churches Ad tuendam fidem Ex corde Ecclesiae Indulgentiarum Doctrina Praedicate evangelium Veritatis gaudium Custom Matrimonial nullity trial reforms of Pope Francis Documents of the Second Vatican Council Christus Dominus Lumen gentium Optatam totius Orientalium ecclesiarum Presbyterorum or...

Topological space

Mathematical space with a notion of closeness In mathematics, a topological space is, roughly speaking, a geometrical space in which closeness is defined but cannot necessarily be measured by a numeric distance. More specifically, a topological space is a set whose elements are called points, along with an additional structure called a topology, which can be defined as a set of neighbourhoods for each point that satisfy some axioms formalizing the concept of closeness. There are several equiv...

 

Ancient Chinese urban planning

How cities were built in the East Asian country before the modern period This article has multiple issues. Please help improve it or discuss these issues on the talk page. (Learn how and when to remove these messages) This article includes a list of general references, but it lacks sufficient corresponding inline citations. Please help to improve this article by introducing more precise citations. (June 2018) (Learn how and when to remove this message) This article possibly contains original ...