| |
GeekInterview.com > Interview Questions > Data Warehousing > ETL
| Print | |
Question: Lets suppose we have some 10,000 odd records in source system and when load them into target how do we ensure that all 10,000 records that are loaded to target doesn't contain any garbage values.
How do we test it. We can't check every record as number of records are huge.
|
| December 12, 2006 14:36:39 |
#3 |
| prav2000 |
CRM Expert Member Since: December 2006 Total Comments: 5 |
RE: Lets suppose we have some 10,000 odd records in so...
|
| You should have proper tesing conditions in your ETL jobs for validating all the important columns before they are loaded into the target. Always have proper rejects to capture records containing garbage values. |
| |
Back To Question | |
