Note You should not optimize a cube's schema if you depend on inner joins between the fact table and dimension tables to exclude fact rows for the cube content. 如果依赖在事实表和维度表之间的内部连接来为多维数据集内容排除事实行,则不应该对该多维数据集执行进行优化。
Ensure that the column on which the Primary Key ( maybe same as Primary Index in many cases ) is to be defined in the driving table / dimension is unique. 确保主键(有些情况下可能称为主索引)上的列在driving表/维度中的定义是惟一的。
This dissertation designed fact table and dimension table correspondingly based on the multi-dimensional analysis theme, used SQL language to format the form of stored procedure, completed the data statistical and analysis in accordance with the set of dimensions and indicators. 实现中根据多维分析主题设计了相应的事实表与维表,采用SQL语句组建存储过程的形式,按照设定的维度和指标完成对数据的统计与分析。
After effectively extracting, transforming, cleaning core business system data with DTS data extract tool, the operation support system load corresponding fact table and dimension table. 利用DTS数据抽取工具能有效对核心业务系统数据进行抽取、转换、清洗,然后装载相应的事实表和维表。
This paper mainly focuses on data warehouses ' data models and the process planning of extract, transform and load, including fact table, dimension table and materialized view. 本文重点分析数据仓库的数据模型和ETL过程设计,包括事实表、维表、实体化视图等。