I obtain a deployment error when I try to make my table historic.
Computed column 'SCD Surrogate Hash Key' in table ' <mytable>' cannot be persisted because the column is non-deterministic.
I think this has to do with the excessive amount of columns in the table: 695 columns, all varchar(2000).
What confuses me is that when I set the hashing algorithms to debug, I still get the same error
I don't have any transformations on this table, its a straight copy from to ODX.
Is there a limit on the amount of fields a History table can have?
Best answer by rory.smithView original