Building automated data profiling with Oracle Warehouse Builder
Oracle Warehouse Builder has a data profiling module which can help with the profiling of information.
Getting ready
Ensure you have Oracle Warehouse Builder installed and configured as per the installation guide. Identify all the source tables required for data profiling.
How to do it...
Oracle Warehouse Builder provides the capability to automate many data profiling scripts. Be aware that the process uses many resources on the source server, so be diligent when they are executed:
- Create a new Oracle Module for each source system. Expand the project, expand Databases, and right-click on Oracle to select New Oracle Module, as shown in the following screenshot:
- The Create Module Wizard ...
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.
