Using the existing OLTP Database design below, I have created ODS Database with Surrogate Key Logic. Kindly suggest me is my method of approach is
SK_Category_Id should be the primary Key it looks fine between two tables.Dimension table primary key should be refer as FK for fact table.
In Dim_category Category_Id is prepopulated column make SK_category_Id as identity column and this should be the FK of fact table.
Please mark it as helpful if it helps.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?