Hi all,
I have been working with Oracle 92. I have no
experience with Oracle Warehouse. In my current
company, I was told the database is a warehouse. I
can connect to it using sql plus or pl/sql developer.
The warehouse looks the same as the database I
worked with before. How do I tell if a
prank
If you enter the following query select 'Data Warehouse' from dual;
and if the database responds with 'Data Warehouse', then your database
is a DW database.
/prank
Data warehouses can be distinguished from their less noble cousins,
the OLTP databases, by the way they're accessed and by
Janet,
A data warehouse is a database. Now if the data warehouse has all of the
data structures of the OLTP database and people are using those tables like one would
expect, then your just using the same instance for both purposes, which is a recipe
for disaster in my opinion. A data
The Ralph Kimball answer:
A DW is a collection of data marts. A Data mart
is typically a fact table surrounded by a collection
of dimension tables.
The Bill Inmon answer:
A DW is a system designed to collect data from an
enterprise for the purpose of creating data marts.
It is not normally
otn.oracle.com read the oracle data warehouse guide.
btw, its kind of ignorant to post the same question here that is on lazydba.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, January 07, 2004 12:04 PM
Hi all,
I have been working