| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic |
|---|---|---|---|---|---|---|---|
Change the Entity Transaction Log Type |
Change the Entity Transaction Log Type (Master Data Services) |
CordeliaGrey |
jiwang6 |
03/14/2017 |
sql |
master-data-services |
how-to |
[!INCLUDE SQL Server - Windows only ASDBMI]
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.