Data Consolidation and Cleansing

First of all, you may have to collect data from several database; it is even possible that the data is not stored in an Oracle database; for example, important data may be stored in Microsoft Excel Worksheets. It also may be necessary to perform data cleansing, especially if you are dealing with raw data. Oracle Warehouse Builder is the tool to use for these tasks.