Compare table contents with the ‘minus’ SQL operator
Jon Emmons discusses a technique for comparing database table records that I have been using at work. We transform data between stages in our data mart with and ETL tool. I have been writing SQL that compares the target table to the source tables. Basically, we verify the ETL by implementing all the business rules a second time in SQL. Makes for fairly easy to use automation of the testing.
