Database Software

Hi,

I have various remote database (SQL Server, Oracle).

I need to replicate those database in staging database and then from that database do a transformation to the datawarehouse database.

I created a source database and staging database in oracle 9i.

Using OWB i created a source module and imported all the metadata information from the remote(SQL) database.

Now i need to import all these stuff to the target database.(just a replica of the remote database in my local machine).

pls let me know how can i import the stuff into the target database without manually creating it.

What i am looking for is some sort of scripts where in i can just run them in the target database.
OR
is there any other way were i can import the tables and the data into the target module directly?
when i tried to do this i got an error saying its a invalid oracle source?
Does this mean that i cannot import the stuff from SQL Server to OWB target module and then deploy to the database??
pls help me in understanding this?

TIA
shankar