BI_Credit
0 view | +0 today
Follow
Your new post is loading...
Your new post is loading...
Rescooped by mohamed ben smida from Analysis Services
Scoop.it!

Creating Degenerated dimension

Creating Degenerated dimension | BI_Credit | Scoop.it

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.


Via Irawan Soetomo
more...
Rescooped by mohamed ben smida from Analysis Services
Scoop.it!

Creating Degenerated dimension

Creating Degenerated dimension | BI_Credit | Scoop.it

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.


Via Irawan Soetomo
more...