The entity relationship

Entities in MDS can be related to each other, just like database tables, which can be connected to each other with FK-PK relationships. Entity relationships are helpful for a data steward to enter values by selecting from a list of names rather than working with codes and keys.

Get Microsoft SQL Server 2014 Business Intelligence Development: Beginner’s Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.