Problem using Surrogate Key generator stage

mydsworld · Post by **mydsworld** » 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.

ray.wurlod · Post by **ray.wurlod** » 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?

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Fri Mar 20, 2009 3:15 am

Can you check the sequence's currval.

mydsworld · Post by **mydsworld** » 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.