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:
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. For more information, see Administrators (Master Data Services).
The entity must exist. 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.
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for