0

Load Order - Extract and Load Question

Incorta 4.5.9

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?

 

Thanks,

Ryan

Reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like Follow
  • 3 wk agoLast active
  • 15Views
  • 1 Following