Best Practice for logging DW loads into audit table.

• david_h_edmonds

  Default port

  Points: 1430

  More actions

  October 18, 2018 at 7:12 am

  #375407

  Hi guys, I am looking for a bit of advice on  loading my DW  audit table.
  I will be recording the following data about each load:

  [Source_Package] [nvarchar](100) NOT NULL,

  [Log_ID] [int] IDENTITY(1,1) NOT NULL,

  [Log_Date] [date] NOT NULL,

  [Added_Row_Count] [int] NOT NULL,

  [Added_Financial_Total] [decimal](11, 2) NOT NULL.

  My actual Fact table load looks like this:

  

  as you can see, I take a row count of new and updated but at the same time, I would like to take a financial total of one of the fields. How best do you think I can achieve this?
  All ideas gratefully received.

  Regards

  Dave