Book Image

Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide

By : Abolfazl Radgoudarzi, Reza Rad
Book Image

Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide

By: Abolfazl Radgoudarzi, Reza Rad

Overview of this book

Table of Contents (19 chapters)
Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Synonyms and standardization


There might be different formats to show a value; for example, a date can be shown as 5/23/2013 or it can be shown as 23rd of May 2013. Knowledge Base has the ability to standardize this format based on a predefined format string. This format string can be defined in the domain properties. There are different format strings for the String, Date, Integer, and Decimal data types.

A word or sentence might have some synonyms that have the same meaning in terms of business understanding but they just appear to be different. DQS has the ability to understand synonyms based on the knowledge that the data steward has provided. For example, MSFT and Microsoft are synonyms, so in this case it would be helpful if the data steward set these values as synonyms and chose one of these as the heading value (which means that this value will be used for standardization consistency).