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. 1. Use SQL Developer to connect to the source environment.

2. 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:

   select count(*) frominv.mtl_system_items_b;
   

3. 3. Review the table and determine if there are any audit columns (create date, modified date, update date, and so on) which can be used to track changes. Should there be such a column...