To support common load strategies from different partners, implement the following new options on a per table basis
- Keep identities: Keeps DW_Id values from source table by using keep identity option in SSIS destination, and using IDENTITY_INSERT ON/OFF with ADO.NET
- Insert destination: Optional insert into raw or valid table instance, thus in essense providing an option for "storage only"
This will allow the dw tables to be used for persistance only, thus performing key assignment in staging and not having to copy natural keys into the dw for fact tables.
There is an additional performance and storage benefit by bypassing the cleansing process in the dw.