Final Table not Updating

[gatorfe]

We have a build that captures sales order data from our ERP system.  The data gets added to our SQL Data Warehouse.  There are 2 staging builds and one delivery build.  The 2 staging tables are truncated and the delivery table is an update.  Recently though the update is not going through.  I see data in the two staging tables a certain way but dont see that information I should in the delivery table.  This something that recently started happening.  I did not create the builds and I lack knowledge in DM.  Is there any suggestions on things I should look at?  Any info would be greatly appreciated.

[MFGF]

What info are you seeing in the log file generated by the build which updates your delivery table? If I were you I would modify the build properties and make sure that Progress, Detail and SQL logging is enabled on the build - that will generate more log info which might help track down what is happening during that build.

Is the build being run as part of a jobstream? Is it possible anything could be killing the build process or jobstream process during the run?

Cheers!

MF.