Physically designing hierarchical dimensions?

From: Vikas Agnihotri <vikasa_at_writeme.com>
Date: Wed, 20 Oct 1999 14:23:54 GMT
Message-ID: <7ukj9a$7ff$1@nnrp1.deja.com>

Kimball's DBMS Mag article on hierarchical dimensions outlines the basics of setting up hierarchical dimensions using a "link" table that contains b-tree-like information, etc.

Seemed interesting, but I couldnt really figure out how to implement it.

For the simple case of a customer dimension hierarchy mentioned in the article, how exactly would one create/maintain this link table?

Thanks,
Vikas

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Oct 20 1999 - 09:23:54 CDT