| |
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.
|
| September 09, 2006 08:14:34 |
#2 |
| jyothy |
Member Since: Visitor Total Comments: N/A |
RE: Lets suppose we have some 10,000 odd records in so...
|
| Select count(*) From from both source table and Target table and compare the result. |
| |
Back To Question | |
