Account Numbers in a Fact Table

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

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.

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