Building record count profiling scripts

Record count profiling scripts are important to understand how much data is available for the solution.

Getting ready

Identify all the tables which will be used in the solution by gathering the information from the Creating a source matrix recipe in Chapter 8, Analyzing the Sources.

How to do it...

Record counts give you a good indication of data volumes, and potentially change data volumes. They will allow you to determine how much information is relevant to the solution.

  1. Use SQL Developer to connect to the source environment.
  2. Build the SQL statement to determine the record counts for each table identified in the source matrix.

    Sample SQL statement: 

    select count(*) from<schema.table_name>;

    Example SQL Statement: ...

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