When we do the Comparison process, do we retrieve all records from Source, all records from Destination, and then process the diff between them on the client? So, we’d have a DB hit to Source, DB hit to Destination, and then client load while processing the difference. Is this correct understanding?
Does this same process occur if the Source and Destination are within the same database?
Does this same process occur if we span databases/database systems (ie SQL Server to Oracle or Oracle to Oracle, etc)?