Orders fact table, containing 100,000,000 rows.
Orders事实表包含100,000,000行。
Finally, your detailed fact table will have billions of records.
最后，您的事实表将拥有数十亿条记录。
Columns in the join clauses in fact table of star schema database.
星型数据库的事实表中join子句中的列。
This implies joins between several dimension tables and the fact table.
这意味着要将几个维表与事实表相联结。
Select rows from a fact table that meet criteria for several dimensions.
从事实表中选择在几个维上符合标准的行。
A fact table contains things that you measure and record-typically Numbers.
事实表包含了所度量和记录的内容——通常是数字。
This is a star schema consisting of a fact table and four dimension tables.
这是一个星型模式，由一个事实表和4个维表组成。
A customer script USES the DB2 load utility to load each file into the fact table.
一个客户脚本使用DB 2Load实用程序将每个文件装载到事实表中。
Logically, each fact table row now represents a document, not a keyword occurrence.
逻辑上，每个事实表行现在代表一个文档，而不是关键词的一次出现。
The results become meaningful once items from the fact table are added to the report.
一旦事实表中的项目加入报表中，结果就变得有意义了。
If this environment is set, only tables specified in the list can be used as fact table.
如果设置了这种环境，那么只有清单中指定的表才可以作为事实表。
If the fact table is large in volume, then the response time may be longer than expected.
如果事实表数据量很大，那么响应时间会比预期长。
This query plan uses hash join for each join between the fact table and a dimension table.
这个查询对每个事实表和维度表之间的连接使用散列连接。
In the initial star schema above, the fact table contains one row for each keyword occurrence.
在前面的初始星型模式中，对于每次的关键词的出现，事实表都包含一行。
The fact table in the dimensional model has a single join with all the other dimension tables.
维度模型中的事实表与其他所有维度表之间存在单一连接。
For example, as shown below, the Location table is a dimension table for the Orders fact table.
例如，如下所示，location表是Orders事实表的一个维度表。
Fact (table) - The fact directive specifies a fact table to be used during star join optimization.
FACT (table)—FACT指令指定在星型连接优化中使用的事实表。
Assume that there is a LINEITEM fact table on one remote source and a PART dimension table on another.
假设在一个远程数据源上有一个lineitem事实表，在另一个远程数据源上有一个part维表。
The actual proportion depends on the distribution of rows with the pushed-down keys in the fact table.
实际的比例取决于事实表中带有下推键的行的分布。
The join between the fact table and any dimension table is an equi-join, which makes a hash join possible.
事实表和任何维度表之间的连接都是等值连接，这使得散列连接成为可能。
Additivity becomes important when you consider the possible summarizations that will occur on a fact table.
当您考虑将在事实表上发生的可能汇总时，相加性就变得很重要。
The previous example only contained a measure that was taken from one fact table in the underlying database.
前面的例子只包含了一个来自底层数据库事实表的一个度量指标。
The level of a dimension table corresponds to number of links it needs to connect to the central fact table.
维度表的层次与它需要连接到中心事实表的连接数目有关。
An index pushdown USES the pushed-down keys to perform index lookups on a foreign key index of the fact table.
索引下推使用下推键执行事实表外键索引的查询。
OLAP queries typically aggregate many rows of the fact table into a relatively small number of summary results.
OLAP查询通常将事实表的许多行聚合成一个相对少量的汇总结果。
This dynamic filter on the fact table reduces the number of rows used in the probe phase of the actual hash joins.
事实表上的动态过滤减少了实际散列连接探测阶段使用的行数。
A dimension table needs a generalized key as the primary key data; this becomes the foreign key in the fact table.
维度表需要作为主键数据的通用键；这将作为事实表的外键。
Choose the simpler star schema if you prefer a model where each fact table rows represents a keyword in a document.
如果希望每个事实表行表示一个文档中的一个关键词，那么选择更简单的星型模式。
Using a typical star schema database design, a fact table might contain sales data by product, region, and time period.
按照典型的星型数据库设计，一个事实表包含按产品、地区和时间段排序的销售数据。
As this query plan shows, keys from more than one hash table build can be pushed down to filter rows of the fact table.
如这个查询计划所示，不止一个散列表的键可以被下推来过滤事实表的行。
应用推荐