DSXchange

Hi
we are using ODBC as target stage, and there is a column sn_key in the target ,it has values starting from 1 to sequence .....
That extra column is genarated and values pased in the target only.
How to achive that ?

balu124 wrote:Hi
we are using ODBC as target stage, and there is a column sn_key in the target ,it has values starting from 1 to sequence .....
That extra column is genarated and values pased in the target only.
How to achive that ?

What is your database? You can either make that column a sequence column in your table. Thus inserting into that number will generate the next number automatically.

Or you can do a lookup on a dummy column in the table which takes the max(col) and use a surrogate key generator stage and place a transformer to add the values from surrogate key generator with the max value to derive the next sequence number.

In particular you can Search the forum. This question has been answered a number of times, as recently as last week.