table account_stuff account_id int, source_file varchar, host_key varchar(huge), open_date date, close_date date #### - For each input file that's loaded - Check it's list of primary keys against the account_stuff host_key for a match. - If there's not a match, add a row. - Check the list of account_stuff 'source_file's host_keys against the imported file. - If there are missing rows, update with a close_date