Import the Source Metadata

In this section, you create modules for each type of design object into which you intend to import metadata.

1. In the Projects Navigator, select a node such as Files.

   • For the selected node, determine the locations from which you intend to ultimately extract data.

   • Then create a module for each relevant location by right-clicking on the node and select New.

2. Import metadata from the various data sources: right-click the module and select Import to extract metadata from the associated location. OWB displays a wizard to guide you through the process of importing data.

   For an example and additional information on importing data objects, see Importing Warehouse Builder Data into Business Intelligence Applications in Oracle Warehouse Builder Sources and Targets Guide.

3. For the metadata you imported, profile its corresponding data. (Optional)

   The next step uses the Data Profiling Option to ensure data quality as described in Overview of Data Profiling in Oracle Warehouse Builder Data Modeling, ETL, and Data Quality Guide.