|
I feel that moving the attribute to the fact is acceptable to me. If you want to stay pure
you could make
the stored value of an asset = 1 and a liability = -1.
You can see how this will meet the requirements for a pure fact table, as well as
providing you the
ability to use the value for other purposes. I suggest 1 and -1, but any two numbers could
work as
well.
You could even get crazy about this and create a lookup asset type table and use the key
from there.
Bottomline, if this simplifies the ultimate goal, then it is one to try.
|
