Redigera

Dela via


Change the Entity Transaction Log Type (Master Data Services)

Applies to: SQL Server - Windows only 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.

The transaction log is saved, as it is for SQL Server 2014 (12.x) Master Data Services.
Member Entity change logs as saved at the row level.

Any attribute change triggers a new row revision.

When using row transaction log type, the entity is stored as a slowly changing dimension Type 4. Type 2 subscription view and Type 4 (History) subscription view are supported. 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:

To change the transaction log type

  1. In Master Data Manager, click System Administration.

  2. On the Manage Model page, select the row for the model of the entity that you want to edit and then click Entities.

  3. On the Manage Entity page, select the row for the entity that you want to update and then click Edit.

  4. Choose the transaction log type in the drop-down list.

  5. Click Save.