Building high and low data profiling scripts
High and low data profiling scripts define the range of values within an attribute. These scripts form the basis of allowable values within the solution. Typical candidates for this type of profiling include the following:
Date attributes
Numeric attributes
Getting ready
Review your semantic data model, and identify all attributes which are required to be validated to fall within a range of acceptable values. Once you have identified the entities in your semantic data model, you need to determine the actual source of the information. This information can be found in Identifying your source of record for your business entities recipe of Chapter 5, The Blueprint, and Creating a source matrix recipe of Chapter 8, Analyzing the Sources. Once you have the necessary information to connect to the system, you need to identify the source tables for the entities.
How to do it...
Basic profiling scripts can give you great insight into the information you...
