Creating your domains
Domains are ways to standardize the datatype and lengths to assign to attributes.
Getting ready
Review your results of data profiling from the Building data lengths data profiling scripts recipe of Chapter 9, Analyzing the Data.
How to do it...
Identifying standard lengths and datatypes for columns by creating domains simplifies the maintenance and management of the data model as follows:
- Click on Tools | Domains Administration:
- Click on Add to include a new domain, as shown in the following screenshot:
- Enter details for the domain ...
Get Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology 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.