Answer Detail: RE: How can we increment the surrogate key value for every insert in to target database

GeekInterview.com > Interview Questions > Data Warehousing > DataStage

Print |

Question: How can we increment the surrogate key value for every insert in to target database

February 02, 2008 12:16:17	#2
wahi80	Member Since: February 2008 Total Comments: 5
RE: How can we increment the surrogate key value for every insert in to target database
Surrogate key generator is available only in Parralle edition in Server mode you will have to use stage variables or pre-defined variables like @inrownum, @outrownum