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