Hi All,
I am getting below warining message and I have delcared as numeric
When checking operator: When binding output interface field "DUPLICATE_REC_COUNT" to field "DUPLICATE_REC_COUNT": Implicit conversion from source type "dfloat" to result type "int32": Possible range/precision limitation.
Please help me on this ,how to resolve.
Thanks and Reagrds
Srini
source type dfloat to result type int32
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 1
- Joined: Sat Apr 24, 2010 7:05 am
- Location: banglore
- Contact:
Hi All,
I am getting this warning message if using Aggregator stage output in 8.1
When checking operator: When binding output interface field "DUPLICATE_REC_COUNT" to field "DUPLICATE_REC_COUNT": Implicit conversion from source type "dfloat" to result type "int32": Possible range/precision limitation.
All the places data tpe is interger(10)
Please help me on this
Thanks and Regards
Srini
I am getting this warning message if using Aggregator stage output in 8.1
When checking operator: When binding output interface field "DUPLICATE_REC_COUNT" to field "DUPLICATE_REC_COUNT": Implicit conversion from source type "dfloat" to result type "int32": Possible range/precision limitation.
All the places data tpe is interger(10)
Please help me on this
Thanks and Regards
Srini
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
When performing an aggregation using the aggregator stage,the output column's datatype will be dfloat by default(internally) though you have mentioned the DUPLICATE_REC_COUNT field's datatype as Integer(10) .
So, mention the aggregation field's output datatype as Double(20) and then use a transformer stage to convert it to integer 10.Else this warning will occur.
So, mention the aggregation field's output datatype as Double(20) and then use a transformer stage to convert it to integer 10.Else this warning will occur.
Last edited by natashab on Wed Sep 01, 2010 1:03 am, edited 2 times in total.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: