Re: Fetching from a hierarchical data structure?

From: Maury Markowitz <maury_at_remove_this.sympatico.ca.invalid>
Date: Mon, 09 Apr 2001 15:11:32 GMT
Message-ID: <EikA6.65322$XV.16166479@news3.rdc1.on.home.com>

"Christoph Pfrommer" <Christoph.Pfrommer_at_oracle.com> wrote in message news:3AD14E79.7CD7461B_at_oracle.com...
> A few words on typical DW architecture: The well known star schema
consists of a
> large fact table (as in your application) and some lookup tables, one for
each
> (hierarchical) dimension. Since lookup tables are having a different
> representation of hierarchies - one column for each level - you are coding
your
> SQL with some joins

Now this certainly sounds like a good idea in performance terms, but doesn't this limit the depth of the hierarchy?

Maury Received on Mon Apr 09 2001 - 10:11:32 CDT