Mload upsert - Does records processed in the same order they are in the input file
My question here is does Mload process records in the same order that the records are in the input file?
Assume in the input file, I have the following records. Key is same. A B C
In the Mload upsert process (update otherwise insert), My assumption is first A record is processed, then B and C. In that case, A will be inserted, B and C are updated since the key is same for all these records.
I think at the end of the acquistion phase, work tables are sorted before the application phase begins. Will the processing order be different than the file layout?. I mean, the system may insert B first, then treat A and C are updates. Please reply.