Hi,
I will try to address it from a different end.
Datawarehousing also very much known as Business Intelligence and different vendor addressing it from different end. Oracle provides lots a tools scattered in many place in 9i like DBMS_OLAP package, Meterialized view, Insert statement to read exrternal file and many more.
If you have SQL Server 2000 and Analysis Service handy with you, install the demo of BI and you will get a hang of it. MS DTS (ETL) helps you to read from different source/format data and pump in to Warehouse DB or to your staging. You can programm your extraction by using DTS object strucuture (DATAPumptask2 etc.) but for basics GUI would be good enough to understand. ETL is very important in DW as that is the basic element to for your warehouse. Informatica is probably the best in this.
DW concepts are same in every platform, so you can get a good idea by reading article from MSDN.
Also, you could do the same in IBM DB2 UDB7.x and OLAP starter kit. It has a full functional demo which can be up & running in a very short time.
You can get enough material on data modelling to start with, in internet if you search by 'STAR Schema design'. DW mainly uses two type modelling as STAR schema, and Snow flake schema. In Star schema there is a fact table which holds summable data at the lowest level and is related with one or more Dimension table by foreign key relationship. Snow flake is further normalisation of the Dimensions. Every warehouse needs a staging area which is more or less like main DW schema but may have more table for pruning, converting and cleaning data for the warehouse.
Trying out demo will give you a strong induction to BI and after that you could use the tools as per your choice.
Thanks,
Debasis Ray