Warnings in Look up stage
Posted: Tue Oct 03, 2006 7:15 pm
Hi
My job design is
Transformer (TRS)
(key,a,b)
|
|
lookup(LKP_ID)----------->dataset(DS)(ID decimal(38,0)NotNull,a,b)
ID decimal(38,0)NotNull
^
|
|
|
oracle stage (GET_ID)
(key,ID decimal(38,0) NotNull)
In the oracle stage
SELECT ID.NEXTVAL FROM DUAL
where 1 = ORCHESTRATE.Key
I am getting the following warnings in the look up stage
1.LKP_ID: When checking operator: When binding output interface field "ID" to field "ID": Implicit conversion from source type "decimal[38,10]" to result type "decimal[38,0]": Possible precision limitation.
2.LKP_ID: When checking operator: When binding output interface field "ID" to field "ID": Converting a nullable source to a non-nullable result;a fatal runtime error could occur; use the modify operator to
specify a value to which the null should be converted.
Please suggest me some ways to overcome this warnings
Thanks
meera
My job design is
Transformer (TRS)
(key,a,b)
|
|
lookup(LKP_ID)----------->dataset(DS)(ID decimal(38,0)NotNull,a,b)
ID decimal(38,0)NotNull
^
|
|
|
oracle stage (GET_ID)
(key,ID decimal(38,0) NotNull)
In the oracle stage
SELECT ID.NEXTVAL FROM DUAL
where 1 = ORCHESTRATE.Key
I am getting the following warnings in the look up stage
1.LKP_ID: When checking operator: When binding output interface field "ID" to field "ID": Implicit conversion from source type "decimal[38,10]" to result type "decimal[38,0]": Possible precision limitation.
2.LKP_ID: When checking operator: When binding output interface field "ID" to field "ID": Converting a nullable source to a non-nullable result;a fatal runtime error could occur; use the modify operator to
specify a value to which the null should be converted.
Please suggest me some ways to overcome this warnings
Thanks
meera