All Forums Tools
Raom 16 posts Joined 12/04
11 Dec 2006
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 orderthat the records are in the input file?Assume in the input file, I have the following records. Key is same.ABCIn 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 differentthan the file layout?. I mean, the system may insert B first, then treatA and C are updates. Please reply.Thanks

Thanks Rao M
Barry-1604 176 posts Joined 07/05
12 Dec 2006

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.

You must sign in to leave a comment.