| title | Change the Entity Transaction Log Type | |
|---|---|---|
| description | Change the Entity Transaction Log Type (Master Data Services) | |
| author | meetdeepak | |
| ms.author | dkhare | |
| ms.reviewer | mikeray | |
| ms.date | 03/05/2026 | |
| ms.service | sql | |
| ms.subservice | master-data-services | |
| ms.topic | how-to | |
| ms.custom |
|
[!INCLUDE SQL Server - Windows only ASDBMI]
[!INCLUDE support-notice]
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 [!INCLUDEssSQL14] [!INCLUDEssMDSshort]. |
| 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. |
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.