regarding surrogate key generation
Moderators: chulett, rschirm, roy
regarding surrogate key generation
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
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
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
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
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
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
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
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
Quote the sequence name.
Code: Select all
KeyMgtGetNextValue('drs14')
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.