Which feature of Oracle Warehouse Builder can be used to help ensure data quality?

Question

Options

• AData extraction
• BData profiling
• CLogical mapping
• DException reporting

• A
  8% (3)
• B
  84% (31)
• C
  3% (1)
• D
  5% (2)

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 full-featured 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: * 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 * 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.

No community discussion yet for this question.