Expose Fact Table Foreign Keys in the package.
在包中显示事实表的外键。
Orders fact table, containing 100,000,000 rows.
Orders事实表包含100,000,000行。
These two dimensions are joined through the sales fact table.
两个维度通过销售事实表连接起来。
This report query requires a full table scan of the fact table.
这个报表查询需要该事实表的一个全表扫描。
Finally, your detailed fact table will have billions of records.
最后，您的事实表将拥有数十亿条记录。
The last factor in key selection is its impact on the fact table.
键选择中的最后一个因素就是它对事实表的影响。
Columns in the join clauses in fact table of star schema database.
星型数据库的事实表中join子句中的列。
There are several important issues to address in fact table design.
事实表的设计中要解决几个重要问题。
This means that the refined fact table now has one row per document.
这意味着改进的事实表现在对于每个文档有一行。
This implies joins between several dimension tables and the fact table.
这意味着要将几个维表与事实表相联结。
Select rows from a fact table that meet criteria for several dimensions.
从事实表中选择在几个维上符合标准的行。
This will be the physical name of the fact table created in the warehouse.
这将是在数据仓库中创建的事实表的物理名称。
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个维表组成。
The result is that the two dimensions will be joined through the sales fact table.
结果是两个维度将会在销售事实表中连接起来。
Logically, each fact table row now represents a document, not a keyword occurrence.
逻辑上，每个事实表行现在代表一个文档，而不是关键词的一次出现。
Since the sales fact table is quite large, the same filter should be applied there.
由于销售事实表非常大，因此使用了同样的过滤。
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.
这个查询对每个事实表和维度表之间的连接使用散列连接。
Fact table rows now represent documents instead of keyword occurrences within the document.
事实表行现在表示文档，而不是关键词在文档中的出现。
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.
维度模型中的事实表与其他所有维度表之间存在单一连接。
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.
前面的例子只包含了一个来自底层数据库事实表的一个度量指标。
应用推荐