When adding a dimension such as currency to a SQL server table, do we have to reload data or can we set the default to USD?
When adding the dimension the Fac table is cleared.