| |
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.
|
| May 05, 2007 09:32:53 |
#5 |
| Maharishi |
Member Since: Visitor Total Comments: N/A |
RE: Lets suppose we have some 10,000 odd records in so...
|
| This is the base line for Error and Reject Handling. use IS_date, IS_number such function to check the data what we are loading following standard format. Don't forget to identify null values and existance of special characters in the data. |
| |
Back To Question | |
