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
warning with join and SQL server
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 397
- Joined: Wed Apr 12, 2006 2:28 pm
- Location: Tennesse
warning with join and SQL server
hi sam here
1. The key mentioned in the Sort stage Sort_475 does not match the keys mentioned in "Join_479" Join stage.
Note: It should exactly match in all the case.
2 and 3. Column "AREA_ID" is marked as Char or Varchar in Input tab of the Join stage and Integer as Output tab of the Join stage.
Note: It should exactly match in all the case.
2 and 3. Column "AREA_ID" is marked as Char or Varchar in Input tab of the Join stage and Integer as Output tab of the Join stage.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
-
- Premium Member
- Posts: 397
- Joined: Wed Apr 12, 2006 2:28 pm
- Location: Tennesse