Back in the old days, when we used to walk to the card punch centers barefoot in the snow uphill both ways and carve our own computer chips out of wood, people performed incremental loads using the following steps:
Open the source and destination files.
Look at them.
Where you see new rows in the source file, copy and paste them into the destination file.
Where you see differences between rows that exist in both files, copy the source row and paste over the destination row.
Doubtless, some of you are thinking, “Andy, you nincompoop, no one cut and pasted production data—ever.” Oh really? I’d wager that in some department in every Global 1000 company, ...