Comment
New Contributor III

With standard tables we have the possibility to use columns with identity (sequence like) value. From the modeling perspective surrogate keys are considered as a good practice. How autocdc handles surrogate keys? You probably don't want your BI tool of choice join the facts and dimension tables on business keys as especially in SCD2 they are not unique.