Previous
Next
Previous |
Next |
The Import Metadata Wizard automates importing metadata from a database into a module in OWB. You can import metadata from Oracle Database and non-Oracle databases. Each module type that stores source or target data structures has an associated Import Wizard, which automates the process of importing the metadata to describe the data structures. Importing metadata saves time and avoids keying errors, for example, by bringing metadata definitions of existing database objects into OWB.
The Welcome page of the Import Metadata Wizard lists the steps for importing metadata from source applications into the appropriate module. The Import Metadata Wizard for Oracle Database supports importing of tables, views, materialized views, dimensions, cubes, external tables, sequences, user-defined types, and PL/SQL transformations directly or through object lookups using synonyms.
When you import an external table, OWB also imports the associated location and directory information for any associated flat files.
|
See Also: These topics in Oracle Warehouse Builder Sources and Targets Guide: |