Home » Developer & Programmer » Data Integration » Extracting, Transforming, and Loading
icon4.gif  Extracting, Transforming, and Loading [message #191204] Tue, 05 September 2006 03:15
Claud
Messages: 17
Registered: July 2006
Junior Member
Hi Guys!

I want to build a demo software to showing the warehouse features in Oracle Database 10g. I am using PL/SQL.

Just for a SIMPLE software,
1. if i make an operational DB first.
a. i make it as a create database for "GENERAL PORPOSE"?
so later the connection is between database(operational) and database (warehouse).

or

b. i make it as a create database for "DATA WAREHOUSE" and then i use a tablespace for the operational DB?
so later the connection is between tablespace (operational) and tablespace (warehouse).

which one is the correct one?

Previous Topic: how to do a expert in OWB?step by step ?
Next Topic: OWB 10g: Define PCTFREE for tables
Goto Forum:
  


Current Time: Thu Mar 28 09:25:51 CDT 2024