Well, I'd say pick up that fat juicy 9i datawarehouse manual and start reading it!
 This is also a sort of an eye opener to all newcomers(we'll after more than 2 1/2 yr exp with oracle I still feel line a newcomer!!) when it comes to saying I'm an Oracle DBA. So when you say you're certified dba and not having studied datawarehousing then I wonder what the employer would make of your cert if he had DWH
 There are sample schema's in oracle 9i where you canstart playing around to exercise the understanding of the basics you picked up from various sources incl oracle manuals etc.
 But don't even try to say you're an datawarehouse specialist if you lack that real world exp in datawarehouse...
But on the +ve note, you gotta begin somewhere, so like i said pick up that juicy fat datwarehouse oracle manual....
I'm a JOLE(JavaOracleLinuxEnthusiast)
--- Everything was meant to be---
Originally posted by grjohnson I reckon the we've helped quester, no doubt there's been a touch of sarcasm in the thread, but only becasue so far, nearly all the information provided can be found on www.oracle.com.
A data warehouse is a subject oriented; time variant. non volatile;
integrated collection of data that supports the decision-making
capabilities of the business user.
A data warehouse contains historical data that is not subject to
change, but is refreshed cyclically.
pls to learn more visit your father's website (sorry, not your father;
father of data warehouse bill inmon i ment): http://www.billinmon.com/