warning with join and SQL server
Posted: Wed Oct 11, 2006 8:33 am
Hi All i am running a parallel job which contain the stages like transformer ,CDC, join, lookup and sort .my source is seq file and target is SQL server .i am getting these 3 types of warning can any one plz help me how to get rid of these warnings
Join_479: When checking operator: User inserted sort "Sort_475" does not fulfill the sort requirements of the downstream operator "APT_JoinSubOperator in Join_479"
Join_479: When checking operator: On input data set 1: When binding input interface field "AREA_ID" to field "AREA_ID": Implicit conversion; from source type "string[max=50]" to result type "int32": Converting string to number
SQLServer_Enterprise_481: When checking operator: When binding output interface field "AREA_ID" to field "AREA_ID": Implicit conversion; from source type "string[max=50]" to result type "int32": Converting string to number
Thanks in Advance
Join_479: When checking operator: User inserted sort "Sort_475" does not fulfill the sort requirements of the downstream operator "APT_JoinSubOperator in Join_479"
Join_479: When checking operator: On input data set 1: When binding input interface field "AREA_ID" to field "AREA_ID": Implicit conversion; from source type "string[max=50]" to result type "int32": Converting string to number
SQLServer_Enterprise_481: When checking operator: When binding output interface field "AREA_ID" to field "AREA_ID": Implicit conversion; from source type "string[max=50]" to result type "int32": Converting string to number
Thanks in Advance