ODBC_CvNew_Ins: When checking operator: When binding input interface field "CL_ID" to field "CL_ID": Implicit conversion from source type "uint64" to result type "int64": Possible range limitation.
In extended option of SKEY stage i have specified as "Unsigned".But still i am getting above warning.
Is there any way i can remove this warning without supress in log.
You could specify unsigned integer in CL_ID, and incur a metadata mismatch instead. Better, of course, is to use an explicit conversion function. Worst case demote the warning using a message handler.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
I have already specified CL_ID in SKEY as "UNSIGNED".It seems sarrogate key is creating CL_ID as "Unsigned" and on target table CL_ID is bigint which is signed.
If it is correct,is there any way i can create CL_ID in skey as Signed...??
No. Surrogate keys are always generated as uint64. But you could change this downstream of the Surrogate Key Generator stage using, perhaps, a Modify or Transformer stage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.