|
If I was to start a data warehouse project from
scratch, I'd make sure that I had some training first.
Data warehouses are different than normal, online
transaction databases. Personally, I took the Data
Warehousing Fundamentals class from Oracle Education.
It was really good in pointing out the basics.
Aside from that, you'll want to make sure that you use
Oracle's best tools available to help with the volume
of data you will be handling. Partitioning is a must
for such large data volumes. Parallel SQL statements
help out greatly too! You'll also want to make sure
that you start with Oracle 9i so you can use many of
the new analytic features available to you. For More Information
|
