How To Validate Tables Contain The Same Data
Use the hp diff
command to compare records across source and target tables.
Differences are output in JSON format separated by new lines, where the source is considered the new dataset and the target is the old (reference) data.
- Supply the primary key fields to sort and join the two datasets for comparison
- Optionally choose the number of differences allowed before exiting