Düzenle

Aracılığıyla paylaş


Subscription View Formats (Master Data Services)

Applies to: SQL Server - Windows only Azure SQL Managed Instance

Based on the entity or derived hierarchy you select, the following formats are available for your subscription view.

Subscription View Formats

Name Description
Leaf Members Contains leaf members and their associated attribute values.
Leaf Members History Contains leaf members' historical data and the associated attribute values. The view format is Slowly Changing Dimension Type 4 style.
Leaf Members SCD Type 2 Contains leaf members' historical and current data, and the associated attribute values. The view format is Slowly Changing Dimension Type 2 style.
Consolidated Members Contains consolidated members and their associated attribute values.
Consolidated Members History Contains consolidated members' historical data and the associated attribute values. The view format is Slowly Changing Dimension Type 4 style.
Consolidated Members SCD Type 2 Contains consolidated members' historical and current data, and the associated attribute values. The view format is Slowly Changing Dimension Type 2 style.
Collection Memberships Contains a list of collections and their associated attribute values.
Collections Contains a list of collections and the members in each, along with weight values and sort order.
Collection Members History Contains collection members' historical data and the associated attribute values. The view format is Slowly Changing Dimension Type 4 style.
Collection Members SCD Type 2 Contains collection members' historical and current data, and the associated attribute values. The view format is Slowly Changing Dimension Type 2 style.
Explicit Parent Child Contains explicit hierarchy structures for an entity in a parent child format.
Explicit Levels Contains explicit hierarchy structures for an entity in level format.
Derived Parent Child (Derived Hierarchy View) Contains a derived hierarchy structure in parent child format.
Derived Levels (Derived Hierarchy View) Contains a derived hierarchy structure in level format.

See Also

Overview: Exporting Data (Master Data Services)
Create a Subscription View to Export Data (Master Data Services)