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
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