Forum Stats

  • 3,734,464 Users
  • 2,246,976 Discussions
  • 7,857,305 Comments

Discussions

Suggestion on design of History table

User_3ZQRH
User_3ZQRH Member Posts: 70 Red Ribbon
edited May 28, 2021 9:44AM in OLAP

Hi,

I am building a live table ( and its' corresponding history table which will hold any changes made to the live table)

As such the history table is not used by the application (except is rare scenario) for audit purpose/tracing back a data quality issue.

There is unique constraint (business validation) built on the Live table. Do I need to replicate the same constraint on the history table as well ? Is that the practice ? or I should not be creating any constraint on history table because it will only be populated via Live table ( and there is already an constraint implemented on the live table)


Note : I have asked in question in SQL forum as well so this might be a duplicate

Sign In or Register to comment.