I have a use case where I need to insert data in salesforce which is being exported from an external system. This data is split over multiple rows, and I need to get those multiple rows into the sobjects. What I do is just insert everything in separate records in salesforce, and based on those separate records I construct records of another type with Apex.
However, Am I sure that records inserted via the dataloader, are inserted in the same order in Salesforce. Say I add a custom field of type Autonumber, can I sort on that field, and be sure that the results I get are in the same order as the results in the upload file.
I have a feeling that the order of the inserted records can possibly be different from the order in an upload file because Salesforce is a multi-tennant environment.