Mload upsert

Tools
Enthusiast

Mload upsert

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
Enthusiast

Re: Mload upsert

Sorry. The same topic has been posted three times.
That was not my intention. I got the error message when
I was trying to post. I thought it was not posted.
But it is there three times.