 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?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
