key genarator

[raju4u]

Hi when i try to genarate one sequence number by using surrogate key genarator i am getting the follwing warning.

Surrogate_Key_Generator_91: When checking operator: When binding output interface field "key" to field "key": Implicit conversion from source type "uint64" to result type "int32": Possible range limitation.

i am not getting the proper sequence.

i have given source name is one temparary file and souerc type is flat file and file initial value is 1. (ver 8.1)

can any body help me on this.

thanks

[ArndW]

The generated key in the stage is a BigInt and your key column is declared as a normal integer. I'd redefine the key as BigInt and, if necessary, explicitly convert to integer later in the job so as to avoid the warning.