Please explain what policy/procedures/validation you would apply to ensure the follow bad data is not stored in the Warehouse

Data Quality - Types of Data Quality Problems

Dummy values in source system fields

Absence of data in source system fields

Multipurpose fields

Cryptic data

Contradicting data

Improper use of name and address lines

Violation of business rules

Reused primary keys

Non-unique identifiers