For example , if a foreach loop container repeats a control flow that updates dimensions and fact tables in a star schema , you can configure a transaction to ensure that all fact tables are updated successfully , or none are updated 例如,如果foreach循环容器重复了星形架构中的维度表和事实数据表的更新控制流,则可以配置事务以确保成功更新所有事实数据表,或者不更新任何事实数据表。
When working with cubes and mining models , integration services can transform non - numeric data to numeric data , and can ensure that data values fall within expected bounds , thus creating clean data from which to populate fact tables and dimensions 使用多维数据集和挖掘模型时, integration services可以将非数值数据转换为数值数据,并且可以确保数据值处于期望的范围内,如此便创建了用来填充事实数据表和维度的干净数据。
A currency identifier associated with an attribute in a dimension table that is then associated with a transaction in the fact table , as is commonly the case in financial applications where a location or other identifier , such as a subsidiary , identifies the currency used for an associated transaction 与维度表中的一个属性相关联然后又与事实数据表中的一个交易相关联的货币标识符,对于使用位置或其他标识符(例如子公司)来标识用于相关交易的货币的财务应用程序来说,通常是这种情况。