regarding surrogate key generation

[Saama]

hi,
iam using ODBC----->TRANSFORMER---->ODBC.
in the o/p stage, i created extra column called id for surrogate key.
i have defined a stage variable called SV and intialized to 1
i have called routine called keymanagement next value and it has parameter called sequencer name.
what shall i enter in the place of sequence name.
plz help me, what shall be the derivation for the o/p column ID .

o.p column id-name of the surrogate key column.


cheers;
saama

[DSguru2B]

The derivation should be KeyMgtGetNextValue(SeqName) where SeqName is nothing but a name that identifies this particular sequence.

[Saama]

hi,
thanks gurus, i really appreciate.
keymanagementnextvalue(@INROWNUMBER)=id
constraint=@inrownumber<10
stage variable 'sv' and assigned to 1.
when i compile and run.its running fine, and iam able to generate surrogate key , the sequence is 3,4,5,6. why iam not getting from 1,2,3,4,5... .plz help me. what shall i do inorder to get surrogate key from 1,2,3,4,5..

plz help me.
cheers;
saama

[Saama]

hi,
thanks gurus, i really appreciate. i have given incomplete information.
in the transformer stage, i have given,
keymanagementnextvalue(@INROWNUMBER)=id
where id is the o/p column in my target stage which i defined manually
constraint=@inrownumber<10
stage variable 'sv' and assigned to 1.
when i compile and run.its running fine, and iam able to generate surrogate key , the sequence is 3,4,5,6. why iam not getting from 1,2,3,4,5... .plz help me. what shall i do inorder to get surrogate key from 1,2,3,4,5..

plz help me.
cheers;
saama

[DSguru2B]

Dont provide @INROWNUM as the sequence name. Give a sensible name. Like maybe JobName. Why do you need the stage variable 'sv' again. If you dont, then get rid of it.

[Saama]

hi gurus,
when i used KeyMgtGetNextValue(drs14*)=id
here id is the o/p column name
drs14= jobname
iam getting error =" variable drs14 is not defined"
i tried various other ways.
only when i use keyMgtGetNextValue(@INROWNUMBER)
I could validate the expression.
but can generate sequences from 3, 4,5,6..
what should i use inorder to validate my expression and need to generate from 1,2,3,4....

plz help me.
cheers;
saama

[DSguru2B]

Quote the sequence name.

Code: Select all

KeyMgtGetNextValue('drs14')

[Saama]

hi gurus,
Thanks very much its working fine.

cheers;
saama

[DSguru2B]

You can now mark the post as resolved.