Source-To-Target Data Validation
Any ideas on how to automate source-to-target "straight move" record level data validation? Currently, we are utilizing Excel Compare.
Re: Source-To-Target Data Validation
Using any one of a couple tools, perhaps you could write some queries to check:
1. Foreign key integrity,
2. Record counts,
3. No orphans,
4. Table descriptions and data-types,
And then add comparison logic, then write differences to a spreadsheet.
VBScript would work well.