Question: what is the difference between update and upsert in data loader?
Answer: In upsert operation Salesforce internally validates the data based on Object's Id or External Id. So, upsert takes little bit longer time than insert or update . Using the upsert operation, you can either insert or update an existing record in one call.