All Forums UDA
rlaskar 18 posts Joined 03/06
22 Mar 2006
Syntax to create surrogate keys in a table

I was trying to create a table with surrogate keys defined.

BBR2 96 posts Joined 12/04
21 Apr 2006

I don't know if you have got any replies on this.We had implemented separate KEY and MAP tables in past.These key tables will have a surrogate key and also their natural key counterpart. In fact the first loading job in the ETL was to load these Key tables. Generate new keys if they don't exist.I don't think there is any direct way to generate Surrogte keys.Vinay

You must sign in to leave a comment.