DSXchange

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

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.