Designing Audit table for Data Warehouse.
Create a table with no refential integrity or identity first using script below.(Alter as needed)
Create Audit Table
Insert Default rows before adding any referential integrity or identity to avoid errors(It is Initial seeding of the Audit Table.
Add the identity and referential integrity to the table.