• The cleansing routine is done during the ETL process. After the data loaded into the dimension table, it is not guaranteed that no one would delete it.

    To put a foreign key in the fact table is used for data integrity.