Expose foreign keys found in fact tables to Transformer modelers.
给 Transformer建模师提供事实表中发现的外键。
The fact tables can be filtered on one or more of their foreign keys.
事实表可以根据一或多个外键过滤。
Using the DB2cmd SQL tool, alter the AW fact tables noted in (a) to enable row compression.
使用DB 2 cmdSQL工具，改变(a)中标注的AW事实表来启动行压缩。
We have already covered fact tables, so in this column we will look at how to design dimension tables.
我们已经讨论过事实表，因此本专栏将关注如何设计维度表。
A dimensional model has three key parts: the fact tables, the dimension tables, and the summary tables.
维度建模包括三个关键部分：事实表、维度表、以及汇总表。
If running DB2 9.1 you will have had to run load management to initially deliver some data to your fact tables.
如果运行DB 2 9.1，您将不得不运行负载管理来初步传递一些数据到您的事实表。
In data warehouses, the size of fact tables or history tables poses challenges to designers and administrators.
在数据仓库中，事实表或历史表的大小是摆在设计人员和管理员面前的一个挑战。
Outer joins can be converted to inner joins by augmenting fact tables with default values for foreign keys.
可通过用针对外键的默认值来填充fact表，来将外部连接转换为内部连接。
Edit the generated SQL script adding the COMPRESS YES clause to the CREATE table statement for the noted fact tables.
编辑生成的sql脚本，对于标记的事实表添加COMPRESSyes子句到CREATEtable语句。
This is how your users are going to make decisions-by comparing facts from different fact tables with different grains.
这就是您的用户将制定决策的方式—比较来自不同粒度的不同事实表的事实。
In the next version of the SAP BW product, the Fact tables will use a multidimensional clustering (MDC) table to store data.
在下一个版本的SAPBW产品中，fact表将使用多维集群(multidimensional clustering,MDC)表来存储数据。
The script below will scan for AW fact tables named using the wildcard expression % _measures and scripts ALTER table and REORG commands.
以下脚本将使用通配符表达式% _ MEASURES以及脚本alterTABLE和REORG命令扫描指定的aw事实表。
A query will typically consist of one or more measures, which are measurement entities from the fact tables that are of interest to the user.
一个查询通常由一个或多个度量组成，这些度量是来自用户感兴趣的事实表的度量实体。
You can query for data about code and other files that are under version control by using the fact tables in the following illustration.
您可以使用下图中的事实资料表来查询受到版本控制之程序码和其他档案的相关资料。
The following script can be edited and run on your warehouse database to generate a script to enable row compression across all AW created fact tables.
以下脚本可被编辑并在您的数据仓库数据库上运行，来生成一个脚本跨所有AW创建的事实表启动行压缩。
Building bitmap join indexes of dimension tables and fact tables directly may bring a large number of useless index items that affect query efficiency.
直接建立维度表与事实表的位图连接索引会产生大量无用的索引项，影响查询效率。
The works include the design of fact tables and dimension tables; the design of metadata; and the design and development of function modules of the StatDB.
包括事实表和维表的设计，元数据结构的设计，及统计库功能模块的设计和实现。
Another benefit of summary tables is that they let you compare results from two different fact tables (maybe even in separate data marts) that have different grains.
汇总表的另一个好处是支持对有不同粒度的两个事实表(甚至可能位于单独的数据市场中)进行比较。
Alternatively, multiple fact tables are often required to represent atomic versus more summarized information or to support richer analysis in a heterogeneous product environment.
另外，经常需要多个事实表来表示最小单元与更多的汇总信息或支持在异构环境下的产品更丰富的分析。
The SET OPTIMIZATION ENVIRONMENT FACT statement can be used to specify a list of tables that can be considered as fact tables during star join optimization for all queries in the current session.
SETOPTIMIZATIONENVIRONMENTFACT语句针对当前会话的所有查询，用于指定一个在星型连接优化中可被视为事实表的表清单。
Now that you understand the process for both the dimension and fact tables, let's look at a real world example to explore how to identify the dimension and measures from the business requirements.
既然您理解了维度和事实表的处理，就让我们看一看真实世界的例子，以探索如何从业务需求中识别维度和测度。
While this global configuration may avoid going through fairly large fact tables and improve performance in many cases, you may encounter scenarios where the dimension tables are also fairly large.
很多情况下，这两项全局配置也许不会对相对较大的事实表起作用，并提升性能，您也许会遇到维度表也很大的情景。
If this environment is set, only tables specified in the list can be used as fact table.
如果设置了这种环境，那么只有清单中指定的表才可以作为事实表。
A star join query typically involves a fact table and several dimension tables, with join predicates between the fact table and each dimension table.
一个星型连接查询通常包含一个事实表和几个维度表，事实表和每个维度表之间都有连接谓词。
Each feature provides a distinct approach to grouping data in a table and provides a unique contribution to addressing needs related to large fact or history tables.
每种特性都为分组表中的数据提供了独特的方法，并对解决与事实表或历史表相关的需求有独特的作用。
It typically has one large central table (called the fact table) and a set of smaller tables (called the dimension tables) arranged in a radial pattern around the fact table.
它通常有一个大型的中心表(称作事实表)和一组小型表(称作维度表)，维度表以放射模式围绕事实表。
Fact (or history) tables in data warehouses make excellent candidates for use with each partitioning feature, as you see in table 4 below.
数据仓库中的事实表(或历史表)非常适合使用上述每种特性，如下面的表4所示。
The primary purpose of a push-down hash join is to reduce number of rows processed from the fact table, which probes each of the hash tables.
下推散列连接的主要目的是减少处理的事实表行数，这样可以探测每个散列表。
In the above, T1 is the fact table with FK-PK relationship with dimension tables T2 and T3.
其中，T1是与维表t2和t3有fk - PK关系的事实表。
The cube models for [HistoricSales] and [CurrentMonthSales] use their respective fact views instead of database tables.
[HistoricSales]和[CurrentMonthSales]的数据集模型分别使用各自的事实视图，而不是数据库表。
应用推荐