Table 2 retrieves data from existing fields in Table 1. The system also creates additional fields in Table 2. Not all fields are transfered from Table 1 to Table 2. These tables may have millions of records so efficentcy is important.
I need to compare that the records are accurately populated in Table2 from Table1.
TABLE 1 TABLE 2