您要查找的是不是:
- In a snowflake schema, only primary dimension tables are joined to the fact table. 在雪花型架构中,只有主维度表才与事实数据表联接。
- The wizard generates a relationship between the column for each parent attribute and the primary key of the dimension table. 向导将生成每个父属性的列与维度表的主键之间的关系。
- In other words, a dimension must be based on a single dimension table directly related to a fact table. 也就是说,维度必须基于与事实数据表直接相关的单个维度表。
- Between the key attribute and each non-key attribute bound to columns in the main dimension table. 在键属性与绑定到主维度表中各列的每个非键属性之间定义。
- For example, the following table defines a dimension table for a time dimension. 例如,下表定义了时间维度的维度表。
- To make a regular hierarchy appear ragged, set a HideMemberIf property of a level to an appropriate value for the underlying dimension table. 若要使规则层次结构变得不规则,请将某个级别的HideMemberIf属性设置为相应的基础维度表值。
- For each dimension, the Schema Generation Wizard generates a dimension table to be included in the subject area database. 对于每个维度,架构生成向导都会生成一个要包含在主题区域数据库中的维度表。
- The fact table for that measure group contains a foreign key column that references members in the dimension table for the Organization dimension. 该度量值组的事实数据表包含一个外键列,该列引用了Organization维度的维度表中的成员。
- The fact table for that measure group contains a foreign key column that references the currency identifiers in the dimension table for that dimension. 该度量值组的事实数据表包含一个外键列,该外键列引用该维度的维度表中的货币标识符。
- For example, you might create five data flows, each copying data from a flat file into a different dimension table in a data warehouse star schema. 例如,可以创建五个数据流,每个数据流都将数据从平面文件复制到数据仓库星形架构中的不同维度表中。
- The wizard generates one relationship for each regular dimension relationship from the fact table to the dimension table's granularity attribute. 向导会为每个从事实数据表到维度表的粒度属性的常规维度关系生成一种关系。
- In a snowflake schema in a data warehouse, a dimension table that is directly related to and usually joined to the fact table. 在数据仓库中的雪花架构中,直接与事实数据表相关并通常联接到事实数据表的维度表。
- Finally, construct the logical model of data market by using multidimensional techniques, and study the design of fact table and every dimension table. 最后,采用多维技术建立了数据集市的逻辑模型,并且对事实表和各个维表的设计进行了研究。
- With SQL Server, this paper designs E-R model for Yeshu palm drinking sale including fact table for drink sale and dimension table for drink sale. 本文以SQL Server为工具,进行椰树饮料销售的E-R模型设计,包括饮料销售事实表和饮料销售维表。
- An intermediate dimension table is in turn joined to both the intermediate fact table and to the fact table on which the measure group specified by the relationship is based. 中间维度表接着同时联接到中间事实数据表和该关系指定的度量值组所基于的事实数据表。
- Fact table has four columns, and has relationships to two dimension tables, as shown in the following table. 事实数据表有四列,并且与两个维度表有关系,如下表所示。
- On the Identify Fact and Dimension Tables page, select Time in the Time dimension table list, and then click Next. 在“标识事实数据表和维度表”页的“时间维度表”列表中,选择Time,然后单击“下一步”。
- Dimension tables contain information about those measures, such as the product that was sold, the month in which it was sold, and so on. 维度表包含有关这些度量值的信息,如售出产品、售出该产品的月份等。
- The disease is still in its primary stage. 这疾病仍然在初发阶段。
- These attributes appear as attribute hierarchies and can be organized into user-defined hierarchies, or can be defined as parent-child hierarchies based on columns in the underlying dimension table. 这些属性显示为属性结构,并且可以组织成用户定义层次结构,或者可以基于基础维度表中的列定义为父子层次结构。
以上内容独家创作,受著作权保护,侵权必究
海词词典,十七年品牌