Load Order - Extract and Load Question
We have a schema where a table in the schema is loaded from a table in the same schema so I have set the load order for the second table to load after the first table. We have validation tests set up so all results are compared and certain tests have been failing so I started looking into what was happening. What I found is that even though the load order is set correctly the second table is missing rows from the first table. When reviewing the scheduled job process it looks as though the load order is followed correctly for the extract but all of the table loads happen after all of the extracts are complete. Is this the expected result from setting the load order? If so is my only option to put the tables that need to be loaded second in a different schema? If that is the case, what is the use of the load order?