How to insert Unknown record in Dimension Tables

The following query will be useful for insert Unknown values into Dimension table. here the value is inserting into Area Dimension table, which has identity column as Key Column.

SET IDENTITY_INSERT BusinessIntelligence.DimArea ON

insert into BusinessIntelligence.DimArea

(AreaKey,Area)

VALUES (-1,'Unknown')

SET IDENTITY_INSERT BusinessIntelligence.DimArea OFF

Hope this will help!.