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.
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.