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.