Account Numbers in a Fact Table

View previous topic View next topic Go down

Account Numbers in a Fact Table

Post  KyleBrigmon on 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

View user profile

Back to top Go down

Re: Account Numbers in a Fact Table

Post  ngalemmo on 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.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: Account Numbers in a Fact Table

Post  KyleBrigmon on 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

View user profile

Back to top Go down

Re: Account Numbers in a Fact Table

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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