All Forums Tools
Raom 16 posts Joined 12/04
11 Dec 2006
Mload upsert

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
Raom 16 posts Joined 12/04
11 Dec 2006

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

Thanks
Rao M

You must sign in to leave a comment.