Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Account Numbers in a Fact Table

2 posters

Go down

Account Numbers in a Fact Table Empty Account Numbers in a Fact Table

Post  KyleBrigmon Tue Dec 22, 2009 1:54 pm

We have an Account Dimension Table where we are capturing fields like Account Pay Category, Company Number, System Identification Number, New Account Profit Code, etc… These fields will be similar across all accounts. If I add the Account Number to the dimension table the table’s size increases with each added Account Number and we will not save the storage space on our system we had hoped. In this case shouldn’t the Account Number be placed in the Fact Table? The data type of the Account Number is char(21).

KyleBrigmon

Posts : 2
Join date : 2009-12-22

Back to top Go down

Account Numbers in a Fact Table Empty Re: Account Numbers in a Fact Table

Post  ngalemmo Tue Dec 22, 2009 2:26 pm

Not sure where you are going with this. Is the current account dimension a 'junk' or 'mini' dimension or is the intent to have one row per account? I can't imagine that there would be so many accounts that dimension table size would be a concern. And, as is usually the case, there are so many more fact rows per dimension row that putting such a field in the fact table is a bad idea all around.
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

Account Numbers in a Fact Table Empty Re: Account Numbers in a Fact Table

Post  KyleBrigmon Tue Dec 22, 2009 2:31 pm

That was our general conclusion. Thanks for the quick response.

KyleBrigmon

Posts : 2
Join date : 2009-12-22

Back to top Go down

Account Numbers in a Fact Table Empty Re: Account Numbers in a Fact Table

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum