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:

  1. Click on Tools | Domains Administration:
    How to do it...
  2. Click on Add to include a new domain, as shown in the following screenshot:
    How to do it...
  3. 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.