data compare between 2 tables with same structure for any changes after etl run

  • i have huge table with lot of data and is also wide. i took a backup of it before procedure is run in test environment. now i am trying to see only using SQL what changed and finally what i am expecting is how many inserts, updates or deletes are there. i have some idea of using EXCEPT in SQL but tables being large and wide i hesitate to run it

Viewing post 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply