DSXchange

Posted: **Thu Mar 19, 2009 7:36 pm**

I am using a Surrogate Key generator stage with database sequence (TESTSCHEMA.TESTSEQ).

Row Gen -> Surr Key Gen -> Seq file

The sequence get exhuasted, but Seq file shows output surrogate key field generated with all 0 values. I dbout the data type is not correct (chosen as BigInt Unsigned).

Please advise.

Posted: **Thu Mar 19, 2009 7:56 pm**

What Source Type have you specified in this stage? If Flat File, have you initialized the state file?

Posted: **Fri Mar 20, 2009 3:15 am**

Can you check the sequence's currval.

Posted: **Fri Mar 20, 2009 5:05 am**

I have used database sequence in the surrogate key stage and able to get its value through NEXTVAL also.It seems the sequenec values are getting advanced but somehow the values are not written into target Seq file stage.

DSXchange

Problem using Surrogate Key generator stage

Problem using Surrogate Key generator stage