imani_technology (8/21/2012)
...we have decided on the Type 2 SCD for the suggested sales price. Now for the next question: where to put it?
How about in your DIMENSION table? in your star-schema data warehouse?
'member, SCD stands for "Slowly Changing DIMENSION" 🙂
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.