I would say it's a bit situation dependant but if you have a date you use in one table to load, say orders that are new or modified since last reload, you can then use the captured OrderID's to load the related Order Line Items for example from another table.
