I would recommend following simple rules for loading Dimension and Fact tables
Dimensions:
1)
No duplicate values in Natural
Keys.
2)
Dummy record (-1) has to be
present in the table, if the table is truncate and load then inserting the dummy row should be first step.
3) The Natural key shouldn't be blank except the dummy record.
Facts:
1)
Any fact field that is not
mapped from source should always be 0.
2)
Any fact field that is mapped
from source should always be NON-0 value.
3)
All mapped fact key values
should tie up with dimensions.
4)
If no date value is received
from source then it will be resolved to 12/31/4444 or any other date you like
5)
If no values for Measures are
received from source then it will be resolved to 0 .
There are many rules to apply, I recommend these are the important ones.
0 comments: