Design mapping applications that first load the data into the dimension tables. And then load the data into the fact table.
Load Rule: If all dimension table loadings are a success then load the data into the fact table.
Load Frequency: Database gets refreshed on daily loads, weekly loads, and monthly loads.
