两个维度通过销售事实表连接起来。
These two dimensions are joined through the sales fact table.
事实表可以根据一或多个外键过滤。
The fact tables can be filtered on one or more of their foreign keys.
事实表的设计中要解决几个重要问题。
There are several important issues to address in fact table design.
最后，您的事实表将拥有数十亿条记录。
Finally, your detailed fact table will have billions of records.
在包中显示事实表的外键。
从事实表中选择在几个维上符合标准的行。
Select rows from a fact table that meet criteria for several dimensions.
检查基础数据库，确保事实表中含有数据。
Check your underlying database to make sure your fact tables contain data.
这个报表查询需要该事实表的一个全表扫描。
This report query requires a full table scan of the fact table.
这将是在数据仓库中创建的事实表的物理名称。
This will be the physical name of the fact table created in the warehouse.
结果是两个维度将会在销售事实表中连接起来。
The result is that the two dimensions will be joined through the sales fact table.
键选择中的最后一个因素就是它对事实表的影响。
The last factor in key selection is its impact on the fact table.
由于销售事实表非常大，因此使用了同样的过滤。
Since the sales fact table is quite large, the same filter should be applied there.
索引下推使用下推键执行事实表外键索引的查询。
An index pushdown USES the pushed-down keys to perform index lookups on a foreign key index of the fact table.
事实表包含了所度量和记录的内容——通常是数字。
A fact table contains things that you measure and record-typically Numbers.
实际的比例取决于事实表中带有下推键的行的分布。
The actual proportion depends on the distribution of rows with the pushed-down keys in the fact table.
如果事实表数据量很大，那么响应时间会比预期长。
If the fact table is large in volume, then the response time may be longer than expected.
Orders事实表包含100,000,000行。
一旦事实表中的项目加入报表中，结果就变得有意义了。
The results become meaningful once items from the fact table are added to the report.
维度模型中的事实表与其他所有维度表之间存在单一连接。
The fact table in the dimensional model has a single join with all the other dimension tables.
这个查询对每个事实表和维度表之间的连接使用散列连接。
This query plan uses hash join for each join between the fact table and a dimension table.
维度表的层次与它需要连接到中心事实表的连接数目有关。
The level of a dimension table corresponds to number of links it needs to connect to the central fact table.
我们已经讨论过事实表，因此本专栏将关注如何设计维度表。
We have already covered fact tables, so in this column we will look at how to design dimension tables.
运行AW负载管理来传递一些初始数据进行一个事实表构建。
Run AW load management to deliver some initial data for a fact build.
维度建模包括三个关键部分：事实表、维度表、以及汇总表。
A dimensional model has three key parts: the fact tables, the dimension tables, and the summary tables.
维度表需要作为主键数据的通用键；这将作为事实表的外键。
A dimension table needs a generalized key as the primary key data; this becomes the foreign key in the fact table.
由于事实来源于多个事实表，所以其建模过程会更加复杂一些。
As facts are taken from multiple fact tables, the modeling process can become more complex.
事实表上的动态过滤减少了实际散列连接探测阶段使用的行数。
This dynamic filter on the fact table reduces the number of rows used in the probe phase of the actual hash joins.
但此选项，仍然会在边上通过连接到普通事实表来检索维度成员。
This option, however, still retrieves the dimension members on the edges through joins to a common fact table.
当您考虑将在事实表上发生的可能汇总时，相加性就变得很重要。
Additivity becomes important when you consider the possible summarizations that will occur on a fact table.
事实表行现在表示文档，而不是关键词在文档中的出现。
Fact table rows now represent documents instead of keyword occurrences within the document.
应用推荐