| |
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.
|
| April 04, 2008 10:22:31 |
#7 |
| masatjai |
Member Since: April 2008 Total Comments: 1 |
RE: 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 numbe
|
1.check the number of records on source and the Target.
Select count(*) from source
Select count(*) from Target
2.consider a column of data type numeric say A on source and the Target
select sum(A) from source group by some key
select sum(A) from Target group by some key.
paste these two results in excel and make the difference of these ,they should all have zeros as the result.
Thanks
masatjai |
| |
Back To Question | |
