Home Service Manager

Modify content in DWDataMart Possible?

Brian_WiestBrian_Wiest Customer Super IT Monkey ✭✭✭✭✭
Management has asked if it is possible to update content in the data warehouse. 
Use case = Some incidents the analyst left the classification as Null
Management would like the value updated. 
Is this possible? Will is affect any other SQL processes?
Thanks

Best Answer

Answers

  • Billy_WilsonBilly_Wilson Member Ninja IT Monkey ✭✭✭✭
    If those incidents have already been groomed out of the Active database, it shouldn't be an issue to set those values. If they are still in the Active db, the etl process will most likely reset the fields to null.

    That being said, I'd highly recommend testing this first :)  Data Warehouse issues are no fun.


  • Conner_WoodConner_Wood Customer Advanced IT Monkey ✭✭✭
    edited September 2017
    I should mention that it is rather lucky you don't have to deal with the "DurationFact" crap.  Such as if you were going to update a status on a ticket that to ensure status history remained accurate you would need to also set the "FinishDateTime" and calculate duration and any other important fields on the latest status for that ticket and then insert a new row with the StartDateTime.... I dunno about InsertedBatchId and UpdatedBatchId, but I think you can see it's quite the nightmare!
Sign In or Register to comment.