Re: Using dimensions

2003-09-30 Thread Tanel Poder
 different understanding docs, please post it here :) Tanel   - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Wednesday, October 01, 2003 3:59 AM Subject: RE: Using dimensions Got a link for this requirem

RE: Using dimensions

2003-09-30 Thread Jamadagni, Rajendra
Title: Using dimensions Got a link for this requirement in the manual?   Raj -Original Message-From: Tanel Poder [mailto:[EMAIL PROTECTED]Sent: Tuesday, September 30, 2003 4:50 AMTo: Multiple recipients of list ORACLE-LSubject: Re: Using dimensions Query rewriting to use

RE: RE: Using dimensions

2003-09-30 Thread Jamadagni, Rajendra
Title: RE: RE: Using dimensions I am out sick today ... glad you found the acronyms ... the F is left to your own imagination. Raj -Original Message- From: Prem Khanna J [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 30, 2003 5:45 AM To: Multiple recipients of list ORACLE-L

Re: Using dimensions

2003-09-30 Thread Tim Gorman
Title: Re: Using dimensions Query rewrite from materialized views does not require dimensions;  they are only used in certain fairly obscure situations. on 9/30/03 1:49 AM, Tanel Poder at [EMAIL PROTECTED] wrote: Query rewriting to use materialized views requires dimensions to be defined

Re: RE: Using dimensions

2003-09-30 Thread Prem Khanna J
OwwThank God Raj hasn't replied yet :-) Thanx Gints. Jp. 30-09-2003 18:24:28, "Gints Plivna" <[EMAIL PROTECTED]> wrote: >google gave me for example such an address >http://www.gaarde.org/acronyms/ > >I'm sure one of hundreds or even thousands > >> -Original Message- >> From: Pre

RE: Using dimensions

2003-09-30 Thread Gints Plivna
RACLE-L > Subject: Re: Using dimensions > > Raj, > > what does TFM & STFW mean ?!! > let me also get used to the list's acronyms :) > > Jp. > > > - Original Message - > > From: Jamadagni, Rajendra > > To: Multiple recipients of list

Re: Using dimensions

2003-09-30 Thread Prem Khanna J
Raj, what does TFM & STFW mean ?!! let me also get used to the list's acronyms :) Jp. > - Original Message - > From: Jamadagni, Rajendra > To: Multiple recipients of list ORACLE-L > Thanks Scott, okay lets forget OLTP .. but I haven't seen any _actual_ uses > of dimensions ... where

Re: Using dimensions

2003-09-30 Thread Tanel Poder
ED]Sent: Monday, September 29, 2003 11:55 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Using dimensions Dimensions are data warehouse constructs.  They are implemented as tables in the database, but have the characteristic of a hierarchy that can be traversed.  F

RE: Using dimensions

2003-09-29 Thread Mark Richard
Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: RE: Using dimensions

RE: RE: Using dimensions

2003-09-29 Thread DENNIS WILLIAMS
basically your saying you use dimensions hand in hand with materialized views. do they have other uses? > > From: "Stephane Paquette" <[EMAIL PROTECTED]> > Date: 2003/09/29 Mon PM 02:39:43 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> &

RE: Using dimensions

2003-09-29 Thread DENNIS WILLIAMS
Raj - There is some melding of DW and OLTP environments at some sites today. Most DW's are separate environments with data extracted from the OLTP on a regular batch schedule. But it is possible to have a combined environment that satisfies both requirements, especially if you are starting from scr

RE: RE: Using dimensions

2003-09-29 Thread rgaffuri
so basically your saying you use dimensions hand in hand with materialized views. do they have other uses? > > From: "Stephane Paquette" <[EMAIL PROTECTED]> > Date: 2003/09/29 Mon PM 02:39:43 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> &

RE: Using dimensions

2003-09-29 Thread Jamadagni, Rajendra
Title: RE: Using dimensions Thanks Dennis ... We have "a" group who design their application as if this is a DW environment, so I thought learning this stuff might be beneficial for "me". I&

RE: RE: Using dimensions

2003-09-29 Thread Stephane Paquette
EMAIL PROTECTED]On Behalf Of [EMAIL PROTECTED]Sent: Monday, September 29, 2003 2:20 PMTo: Multiple recipients of list ORACLE-LSubject: Re: RE: Using dimensions Thanks Scott, okay lets forget OLTP .. but I haven't seen any _actual_ uses of dimensions ... where does one use them? in SQLs

RE: Using dimensions

2003-09-29 Thread DENNIS WILLIAMS
Raj - Actually a good place to start is the Oracle9i Data Warehousing Guide http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96520/logical. htm#97703 I think it is important for all Oracle DBAs to

Re: RE: Using dimensions

2003-09-29 Thread rgaffuri
ajendra" <[EMAIL PROTECTED]> > Date: 2003/09/29 Mon PM 12:14:39 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: Using dimensions > > Thanks Scott, okay lets forget OLTP .. but I haven't seen any _actual_ uses > of dimensions ... whe

RE: Using dimensions

2003-09-29 Thread Jamadagni, Rajendra
y, September 29, 2003 11:55 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Using dimensions Dimensions are data warehouse constructs.  They are implemented as tables in the database, but have the characteristic of a hierarchy that can be traversed.  For example:  a time dim

RE: Using dimensions

2003-09-29 Thread Scott Canaan
Title: Using dimensions Dimensions are data warehouse constructs.  They are implemented as tables in the database, but have the characteristic of a hierarchy that can be traversed.  For example:  a time dimension can have the hierarchy of date, day, week, month, quarter, year, decade, cent