Friday 21 August 2015

Degenerate Dimension

A degenerate dimension is a dimension that is stored in a fact table or data that is dimensional in nature but stored in a fact table. There may be more than one degenerate dimension inside a fact table.

Ex: 

dimension attributes such as invoice number,order number,invoice id  present in fact table can all be classified as degenerate dimensions.
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

A fatal error occurred while processing the request. The server responded with: FOProcessor cannot run without a valid TMP directory. Please check if TMP directory exist and write enabled.

When attempting to export a Dashboard to Excel the following error message in sawlog is found: A fatal error occurred while processi...