| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Data Warehouse Suggestions
Kathy -
I was in your shoes not so long ago. The best books on the subject are The Datawarehouse Toolkit by Ralph Kimball and Building the Datawarehouse by Bill Inmon. Though I got more out of the books after about 6 months on the DW monkey train.
The whole star schema thing was counter intuitive to my relational brain at the start. But my mentor insisted that everything is either a measured fact or a dimensional attribute. He was so right. So go with that.
We happen to use Discoverer and Actuate. I really like Discoverer and Actuate is an OK report delivery solution. We're looking at going all the way with the Oracle reporting suite (Disco, Reports, Portal...).
As far as ETL tools, we just use sqlldr, sqlplus, ksh, and some perl. Works great for us, but i'm pretty old school. I'm not the person to ask about the heavy weight etl tools. I've heard that sometimes they do more harm than good.
I love the discipline - most satisfying job i've ever held. Have fun!
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of kathy duret
> Sent: Thursday, July 14, 2005 9:27 AM
> To: oracle-l_at_freelists.org
> Subject: Data Warehouse Suggestions
>
>
> Brand new to Datawarehouse and Data Mining.
>
> Looking for good book and paper suggestions as where
> to start.
>
> We are going to start small and grow it.
>
> We want to be able to do What if scenarios eventually
> so I know that I will need to build cubes and star
> schemas.
>
> Users will need reports that can take parameters ... I
> personally hate Crystal, have used Oracle Reports and
> Discoverer but wonder about Cognos and Brio tools. We
> have Oracle Apps so we do have licenses already for
> Discovery and Oracle Reports...
>
> Tips on ETL tools would help although I think we are
> going to use Rhapsody because we have it already but
> we are open
>
> Anyway, any suggestions, tips, food for thought would
> help. This is a healthcare application.
>
> I don't see users being able to do their own adhoc
> reports at this time but it is certaininly a
> possibility 1 year or so down the road.
>
> Thanks so much ..
>
> Kathy Duret
> new DW monkey
>
>
>
> ____________________________________________________
> Start your day with Yahoo! - make it your home page
> http://www.yahoo.com/r/hs
>
> --
> http://www.freelists.org/webpage/oracle-l
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jul 14 2005 - 10:30:26 CDT
 |
 |