Junk Dimension vs Degenerate Dimension
来源:互联网 发布:群发软件哪个好 编辑:程序博客网 时间:2024/05/02 19:59
Junk Dimension
A junk dimension is a convenient grouping of typically low-cardinality flags and indicators. By creating an abstract dimension, these flags and indicators are removed from the fact table while placing them into a useful dimensional framework.A Junk Dimension is a dimension table consisting of attributes that do not belong in the fact table or in any of the existing dimension tables. The nature of these attributes is usually text or various flags, e.g.non-generic comments or just simple yes/no or true/false indicators. These kinds of attributes are typically remaining when all the obvious dimensions in the business process have been identified and thus the designer is faced with the challenge of where to put these attributes that do not belong in the other dimensions.
Degenerate Dimension
A degenerate dimension is a key, such as a transaction number, invoice number, ticket number, or bill-of-lading number, that has no attributes and hence does not join to an actual dimension table. Degenerate dimensions are very common when the grain of a fact table represents a single transaction item or line item because the degenerate dimension represents the unique identifier of the parent. Degenerate dimensions often play an integral role in the fact table's primary key. e.g. composite keys
- Junk Dimension vs Degenerate Dimension
- Fact dimension and degenerate dimension
- Dimensional Modelling - Junk Dimension
- Dimension
- dimension
- Dimension Resources
- Oracle Dimension
- CSS Dimension
- Dimension Role
- Oracle Dimension
- leading dimension
- Leading dimension
- Leading dimension
- VC Dimension
- Dimension作用?
- dimension适配
- VC Dimension
- css dimension
- EndNote使用技巧之一--参考文献的导入
- apache配置https协议(试验OK)
- 基础架构通信协议
- 营销辅助测试包数据库部署
- linux虚拟机VirtualBox共享文件挂载
- Junk Dimension vs Degenerate Dimension
- std::map的insert和下标[]访问
- 清除excel的重复行
- 黑马程序员——正则表达式
- 代码规范总结(不断更新...)
- 黑马程序员——枚举
- 智能手机决战2014:蛋糕如何分,方向在哪里
- 相关的意义
- 黑马程序员——反射