更改实体事务日志类型 (Master Data Services)Change the Entity Transaction Log Type (Master Data Services)
适用于:Applies to: SQL ServerSQL Server(所有支持的版本)
SQL ServerSQL Server (all supported versions) - 仅限 Windows
Azure SQL 托管实例Azure SQL Managed Instance
Azure SQL 托管实例Azure SQL Managed Instance适用于:Applies to:
SQL ServerSQL Server(所有支持的版本)
SQL ServerSQL Server (all supported versions) - Windows only
Azure SQL 托管实例Azure SQL Managed Instance
Azure SQL 托管实例Azure SQL Managed Instance
可以将实体的事务日志类型更改为属性、成员或无。You can change the transaction log type of an entity, to attribute, member, or none.
事务日志类型Transaction Log Type | 说明Description |
---|---|
属性Attribute | 在属性级别保存实体更改日志。Entity change logs are saved at the attribute level. 保存事务日志,因为它是针对的 SQL Server 2014 (12.x)SQL Server 2014 (12.x) Master Data ServicesMaster Data Services 。The transaction log is saved, as it is for SQL Server 2014 (12.x)SQL Server 2014 (12.x) Master Data ServicesMaster Data Services. |
成员Member | 在行级别保存实体更改日志。Entity change logs as saved at the row level. 任何属性更改都将触发新的行修订。Any attribute change triggers a new row revision. 当使用行事务日志类型时,实体存储为缓慢更改维度类型 4。When using row transaction log type, the entity is stored as a slowly changing dimension Type 4. 支持类型 2 订阅视图和类型 4(历史记录)订阅视图。Type 2 subscription view and Type 4 (History) subscription view are supported. 有关详细信息,请参阅订阅视图格式 (Master Data Services)For more information, see Subscription View Formats (Master Data Services) 提供较好的性能。Provides better performance. |
无None | 不保存任何更改日志。No change logs are saved. 提供最好的性能。Provides the best performance. |
先决条件Prerequisites
若要执行此过程:To perform this procedure:
必须有权访问“系统管理”功能区域。有关详细信息,请参阅功能区域权限 (Master Data Services)。You must have permission to access the System Administration functional area.For more information, see Functional Area Permissions (Master Data Services).
您必须是模型管理员。You must be a model administrator. 有关详细信息,请参阅 管理员 (Master Data Services)。For more information, see Administrators (Master Data Services).
实体必须存在。The entity must exist. 有关详细信息,请参阅创建实体 (Master Data Services)。For more information, see Create an Entity (Master Data Services).
更改事务日志类型To change the transaction log type
在主数据管理器中,单击“系统管理” 。In Master Data Manager, click System Administration.
在“管理模型” 页上,选择要编辑的实体模型行,然后单击“实体” 。On the Manage Model page, select the row for the model of the entity that you want to edit and then click Entities.
在“管理实体” 页上,选择要更新的实体行,然后单击“编辑” 。On the Manage Entity page, select the row for the entity that you want to update and then click Edit.
在下拉列表中选择事务日志类型。Choose the transaction log type in the drop-down list.
单击“保存” 。Click Save.