Re: Datawarehousing help

2002-05-07 Thread bill thater
[EMAIL PROTECTED] wrote: I was hoping she would figure out the DW hard stuff, then write the book explaining everything with lots of big, colorful pictures...(big grin). If I were to write the book, and she be the tech editor, then she would drive down to Philly and kick myand shove

Re: Datawarehousing help

2002-05-07 Thread Yechiel Adar
| || | |+--- | || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: Re: Datawarehousing help| | Hello Dennis SAS has progressed

Re: Datawarehousing help

2002-05-07 Thread Thomas Day
] Sent by: rootcc: Subject: Re: Datawarehousing help

RE: Datawarehousing help

2002-05-07 Thread Rachel_Carmichael
| || | |+--- | || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: RE: Datawarehousing help

RE: Datawarehousing help

2002-05-07 Thread Rachel_Carmichael
| || | |+--- | || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: RE: Datawarehousing help| | A DW is not simply a collection of data marts. A DW may

RE: Datawarehousing help

2002-05-07 Thread Scott . Shafer
To: Multiple recipients of list ORACLE-L Subject: RE: Datawarehousing help you people are soo funny. Writing a book takes time, hard work and more energy than I care to commit to the project.. especially on a subject with which I have zero experience -- Please see the official ORACLE-L FAQ

RE: Datawarehousing help

2002-05-07 Thread Grabowy, Chris
Carmichael) | | Subject: RE: Datawarehousing help| | Someone's got to pick up Marlene's slack... -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 5:44 PM To: Multiple recipients

RE: Datawarehousing help

2002-05-07 Thread Rachel_Carmichael
| || | |+--- | || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: RE: Datawarehousing help

Re: Datawarehousing help

2002-05-06 Thread Cherie_Machler
Rachel, Are you licensed for Oracle Designer? We put the estimated row counts for each table into Designer and it produces a nice report showing sizing estimates per table or index, tablespace, and database. Pretty painless. You still need to add on extra space for archives, exports,

RE: Datawarehousing help

2002-05-06 Thread Rachel_Carmichael
] | | cc: (bcc: Rachel Carmichael) | | Subject: RE: Datawarehousing help| | Rachel - I always find it helpful to understand something if I know the origins. I worked with SAS several years ago. At that time

Re: Datawarehousing help

2002-05-06 Thread Rachel_Carmichael
: Rachel Carmichael) | | Subject: Re: Datawarehousing help| | Hello Dennis SAS has progressed a little in the last years and now offer a complete DW solution, including ETL tools. You can use their tools also

Re: Datawarehousing help

2002-05-06 Thread Pat Hildebrand
Rachel, I haven't used their warehouse stuff and it has been a few years since I had to deal with people doing statistical analysis with SAS (by the way very good for that so if the reason considering this is the need for heavy duty statistical analysis that is a big plus) but the one thing that

RE: Datawarehousing help

2002-05-06 Thread paquette stephane
| || | |+--- | | | | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: RE: Datawarehousing help

RE: Datawarehousing help

2002-05-06 Thread Jared . Still
respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Datawarehousing help Dennis, Forgetting about normalization won't be a problem, I've always been more practical than by the book. As for amounts of data being

RE: Datawarehousing help

2002-05-06 Thread Rachel_Carmichael
) | | Subject: RE: Datawarehousing help| | A DW is not simply a collection of data marts. A DW may be a true 'warehouse' of enterprise data from which DM may be built. Extracts go to the DW, DW is used to build DM. A DW may in fact

RE: Datawarehousing help

2002-05-06 Thread Miller, Jay
Just wanted to reiterate the grain recommendation. The growth rate of our data warehouse increased app. 20x when the business side changed their mind from monthly to daily on our largest fact table. They did this one week after we got the monthly table into production as per their original

RE: Datawarehousing help

2002-05-06 Thread Grabowy, Chris
| || | |+--- | || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: RE: Datawarehousing help| | A DW

RE: Datawarehousing help

2002-05-06 Thread Rachel_Carmichael
| || | |+-- | || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: RE: Datawarehousing help| | Just wanted to reiterate

Re: Datawarehousing help

2002-05-06 Thread bill thater
[EMAIL PROTECTED] wrote: Cool!! Here comes Oracle Data Warehousing 101... um knowing the way the goddess feels about book writing, i wouldn't go there if i were you.;-) unless, of course, you're going to write the book for her to edit.;-) -- -- Bill Shrek Thater

RE: Datawarehousing help

2002-05-06 Thread dmeng
: root@fatcity.Subject: RE: Datawarehousing help com

RE: Datawarehousing help

2002-05-06 Thread Rachel_Carmichael
| || | |+--- | || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: RE: Datawarehousing help

RE: Datawarehousing help

2002-05-06 Thread Grabowy, Chris
I was hoping she would figure out the DW hard stuff, then write the book explaining everything with lots of big, colorful pictures...(big grin). If I were to write the book, and she be the tech editor, then she would drive down to Philly and kick myand shove the already burning manuscript

RE: Datawarehousing help

2002-05-06 Thread Grabowy, Chris
| || | |+--- | || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: RE: Datawarehousing help| | Cool!! Here comes Oracle Data Warehousing 101... -Original Message- [mailto

RE: Datawarehousing help

2002-05-06 Thread Jared . Still
consultant that really knows how to design DW. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/06/2002 02:23 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Datawarehousing help Hi Jared

RE: Datawarehousing help

2002-05-06 Thread Kimberly Smith
: (bcc: Rachel Carmichael) | | Subject: RE: Datawarehousing help| | A DW is not simply a collection of data marts. A DW may be a true 'warehouse' of enterprise data from which DM may be built. Extracts go

Re: Datawarehousing help

2002-05-05 Thread Yechiel Adar
Hello Dennis SAS has progressed a little in the last years and now offer a complete DW solution, including ETL tools. You can use their tools also to populate and query oracle. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent:

RE: Datawarehousing help

2002-05-05 Thread DENNIS WILLIAMS
Yechiel - I did not mean to imply that SAS had not improved since the '80s. They would be out of business otherwise. And of course every DW vendor is full solution vendor. Just read their brochures if you don't believe me. My point was that if you understand a company's roots, then often a lot of

RE: Datawarehousing help

2002-05-03 Thread DENNIS WILLIAMS
Rachel - I always find it helpful to understand something if I know the origins. I worked with SAS several years ago. At that time it was a statistical analysis package. A scientist or engineer could load a set of test data into it and perform various arithmetic and statistical analyses. Today

RE: Datawarehousing help

2002-05-03 Thread Kimberly Smith
Excellent dude. -Original Message- WILLIAMS Sent: Friday, May 03, 2002 5:48 PM To: Multiple recipients of list ORACLE-L Rachel - I always find it helpful to understand something if I know the origins. I worked with SAS several years ago. At that time it was a statistical analysis