|
二、集成的
Data on a given subject is integrated.
In many organizations, data resides in diverse independent systems, making it difficult to integrate the information into a single set of meaningful data from analysis. A key characteristic of a warehouse is that data is completely consolidated or integrated. Data is structured in a globally accepted manner, even when the underlying source data is structured differently (conforming dimension). Integration and transformation processes can be time-consuming and costly. It requires commitment from every part of the organization, particularly top-level managers who make the decisions and allocate resources and funds.
因此,主要的工作如下:
1、同一不同组织的维度体系
2、维度表的设计(关于非空和约束机制)
3、中间转换表
4、维度的处理方式
需要注意的是:
我们无法控制和识别人为的错误。 |
|