Which hierarchy type should you use?

You are creating a SQL Server Master Data Services (MDS) model for a company.
The source data for the company is stored in a single table that contains the manager-tosubordinate relationships.
You need to create a hierarchy representing the organizational structure of the company.
Which hierarchy type should you use?

You are creating a SQL Server Master Data Services (MDS) model for a company.
The source data for the company is stored in a single table that contains the manager-tosubordinate relationships.
You need to create a hierarchy representing the organizational structure of the company.
Which hierarchy type should you use?

A.
Natural

B.
Explicit

C.
Parent

D.
Recursive

Explanation:
http://technet.microsoft.com/en-us/library/ff487006.aspx
http://msdn.microsoft.com/en-us/library/ee633747.aspx

http://technet.microsoft.com/en-us/library/ee633759.aspx



Leave a Reply 1

Your email address will not be published. Required fields are marked *