Mload upsert - Does records processed in the same order they are in the input file

Tools
N/A

Mload upsert - Does records processed in the same order they are in the input file

Hi,

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.

Thanks
1 REPLY

Re: Mload upsert - Does records processed in the same order they are in the input file

Yes, rows that have the same primary index value (not necessarily primary key) will be processed in the same order as they are in the input file.