Wednesday, December 26, 2012

Import Source Data Structures from Oracle To OWB


Note: I have used Oracle Warehouse Builder 11.2.0.1

Start the Design Center
Start button -> All Programs -> Oracle 11g Installation (Name) -> Warehouse Builder -> Design Center

Import Source Data Structures from Oracle


You can see that there are no object in the ORACLE_MODULE1.
  

Import Source Data Structures from Oracle


Click Right  -> Choose Import  -> Database Objects ...


Import Source Data Structures from Oracle

Choose the objects (from the source database) to be imported. Click on "Next".


Import Source Data Structures from Oracle

Choose the objects to be imported / re-imported.  Click on "Next".

Import Source Data Structures from Oracle

From the summary screen, choose "Finish" button. 

You will see the following screen:

Import Source Data Structures from Oracle

When the import is done you will see:

Import Source Data Structures from Oracle

You probably will click on "OK" to make the import permanent.

If you click on the "OK" button, you will see the tables imported in the Oracle Warehouse Builder (Navigator):

Import Source Data Structures from Oracle


Save this import :  Ctrl + S