Which feature of Oracle Warehouse Builder can be used to help ensure data quality?
A.
Data extraction
B.
Data profiling
C.
Logical mapping
D.
Exception reporting
Explanation:
After you connect to your data sources in Oracle Warehouse Builder (including
Oracle databases, sources accessed through gateways, and flat file sources) you can apply fullfeatured data profiling to generate statistics about data quality, and to discover complex patterns,
foreign key relationships, and functional dependencies. You can then design complex data rules
and create data auditors to monitor compliance with those rules in any source or target system in
your landscape, regardless of whether those sources are loaded using Oracle Warehouse Builder
or other ETL tools.
For customers who have selected solutions other than Oracle Warehouse Builder for data profiling
and data quality, these can be applied independently of Oracle Warehouse Builder ETL and
design features.
Note: Oracle Warehouse Builder is a full-featured data integration, data warehousing, data quality
and metadata management solution designed for the Oracle database. Oracle Warehouse Builder
is an integral part of Oracle Database 11g Release 2 (11.2) and is installed as part of every
database installation (other than Oracle Database XE).
The major feature areas of Oracle Warehouse Builder include:
*Data modeling
*Extraction, Transformation, and Load (ETL)
*Data profiling and data quality
*Metadata management
*Business-level integration of ERP application data
*Integration with Oracle business intelligence tools for reporting purposes
*Advanced data lineage and impact analysis
Oracle Warehouse Builder is also an extensible data integration and data quality solutions
platform. Oracle Warehouse Builder can be extended to manage metadata specific to any
application, and can integrate with new data source and target types, and implement support for
new data access mechanisms and platforms, enforce your organization’s best practices, and
foster the reuse of components across solutions.
Reference: Oracle Warehouse Builder Concepts, 11g Release 2 (11.2), 2 Introduction to Oracle
Warehouse Builder
http://docs.oracle.com/cd/E11882_01/owb.112/e10581/intro.htm