Datawarehouse dimension Q

From: Markus Janscha <markus_at_janscha.co.uk>
Date: 2000/05/14
Message-ID: <8fls7i$54t$1_at_gxsn.com>#1/1


I trying to build a R-DW using the star schema.

My problem is one of the dimensions.
Assuming my table is as follows 10000 accounts(static) with a maximum of 3 parent levels:

accounts (account_number,account_description,parent1,parent2,parent3)

which I believe is fine.
But what about the parent description? Do I add this to the account dimension?
Also some accounts may only have one or two parent levels does this matter?

Thanks

Markus Received on Sun May 14 2000 - 00:00:00 CEST

Original text of this message