Datacleansing with Oracle Warehouse Builder

In the link Managing Dates Quality can be agreed to an article of Ron Hardman on how carry out data cleaning processes with Oracle Warehouse Builder.

The article begins with an introduction to the quality of the data and ways to negotiate it, being one of them the utilization of the data cleaning options of Oracle Warehouse Builder.

The interesting thing is that is shown how to discharge a script with data of test, and how to configure the tool to test the utilities of Profiling, definition of Rules (Dates Rules), and correction or cleaning of the data. In this manner can be seen and to test in a simple way how to implement a basic process of Dates Cleansing with this tool.

The original article is in English but seeking in the web of Oracle I have found the 3 documents that enclosed, translated the Spaniard, and related to OWB and the cleaning of data:

  • Executive report - Oracle Warehouse Builder 11g Version 1 General Information
  • Oracle Warehouse Builder Dates Quality Option
  • Oracle Warehouse Builder Enterprise ETL Option
AttachmentSize
oracle_warehouse_builder_11g_overview_cast.pdf1.06 MB
Oracle-Warehouse-Builder-11g-Data-Quality-Option.pdf228.7 KB
Oracle-Warehouse-Builder-11g-ETL-Option.pdf180.56 KB