Faizal

• Aug 30th, 2011

 

You have to test all the transformations in your ETL and write negative scenarios.

Sreedhar Lokaray

• Nov 3rd, 2011

 

Let me just give the Data quality problems. If I explain it will go page by page.

1. Dummy values in source system fields.
2. Absence of data in source system fields.
3. Multipurpose fields.
4. Cryptic data
5. Contradicting data
6. Improper use of name and address lines
7. Violation of business rules.
8. Reused primary keys
9. Non unique identifiers.