Building significant columns data profiling scripts

Significant columns are the proposed natural columns you will be using in your dimensions to uniquely identify an individual record for the dimension. These keys determine the grain of the dimension.

Getting ready

Identify all the dimension entities within your semantic data model and determine the source tables for these dimensions.

How to do it...

Significant columns may differ from the natural key of the table:

  1. Connect to the source system using Oracle SQL Developer.
  2. Build a SQL statement to validate the grain of the dimension.

    Sample SQL statement: 

    select <attribute_name>, <attribute_name>, <attribute_name> , count(*) from <schema.table_name> group by <attribute_name>, <attribute_name>, <attribute_name>; ...

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.

Start your free trial