| |
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.
|
| February 02, 2007 07:28:48 |
#4 |
| RufusA |
Member Since: Visitor Total Comments: N/A |
RE: Lets suppose we have some 10,000 odd records in so...
|
| To do this, you must profile the data at the source to know the domain of all the values, get the actual number of rows in the source, get the types of the data in the source. After it is loaded into the target, this process can be repeated i.e. checking the data values with respect to range, type, etc and also checking the actual number of rows inserted. If the result before and after match, then we are OK. This process is automated typically in ETL tools. |
| |
Back To Question | |
