About: Degenerate dimension

Facets (new session)
Description
Metadata
Settings
- Rule:
- Inverse Functional Properties:
- "Same As":

About: Degenerate dimension Goto Sponge NotDistinct Permalink

An Entity of Type : owl:Thing, within Data Space : dbpedia.org associated with source document(s)
QRcode icon

According to Ralph Kimball, in a data warehouse, a degenerate dimension is a dimension key 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:

Attributes	Values
rdfs:label	Degenerate dimension (en)
rdfs:comment	According to Ralph Kimball, in a data warehouse, a degenerate dimension is a dimension key 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: (en)
dct:subject	Data warehousing Metadata
Wikipage page ID	5111172 (xsd:integer)
Wikipage revision ID	1119189834 (xsd:integer)
Link from a Wikipage to another Wikipage	Data warehousing Data warehouse Metadata Dimension table Measure (data warehouse) Fact table Ralph Kimball
Link from a Wikipage to an external page	http://www.kimballgroup.com/2003/06/03/design-tip-46-another-look-at-degenerate-dimensions/%7Cwork=Fact
sameAs	Degenerate dimension Degenerate dimension Degenerate dimension
dbp:wikiPageUsesTemplate	dbt:Cite_web dbt:Cquote dbt:ISBN dbt:Reflist dbt:Use_dmy_dates dbt:Data_warehouse
has abstract	According to Ralph Kimball, in a data warehouse, a degenerate dimension is a dimension key 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. (en)
prov:wasDerivedFrom	wikipedia-en:Degenerate_dimension?oldid=1119189834&ns=0
page length (characters) of wiki page	3634 (xsd:nonNegativeInteger)
foaf:isPrimaryTopicOf	wikipedia-en:Degenerate_dimension
is Link from a Wikipage to another Wikipage of	Dimension (data warehouse) Degeneracy Outline of databases
is foaf:primaryTopic of	wikipedia-en:Degenerate_dimension

Faceted Search & Find service v1.17_git147 as of Sep 06 2024

Alternative Linked Data Documents: ODE Content Formats:

RDF

ODATA

Microdata

About

OpenLink Virtuoso version 08.03.3331 as of Sep 2 2024, on Linux (x86_64-generic-linux-glibc212), Single-Server Edition (378 GB total memory, 52 GB memory in use)
Data on this page belongs to its respective rights holders.
Virtuoso Faceted Browser Copyright © 2009-2024 OpenLink Software