I am working on my first data mart. It is going to be populated with natural disaster data for one particular disaster, a flood.
My question is, would it be feasible to include prior year value, and post disaster value within the same record in my DimAffectedProperty table?
There will never been any edits or editions once the DimAffectedProperty table is loaded so I wasn't sure if it would hinder performance to break out the initial insert into SDC types of records or to just include the historical data in columns within one row.
I appreciate any feedback, personal experiences, etc. you can give.
Thanks!
HawkeyeDBA