Implicit conversion issue in oracle stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
kshaikacc
Participant
Posts: 1
Joined: Tue May 22, 2007 4:28 am

Implicit conversion issue in oracle stage

Post by kshaikacc »

hi,
i am facing an issue while moving data from oracle to oracle.
getting the following warning messages

1.TargetStage: When checking operator: When validating export schema: At field "Column_name1": "null_field" length (0) must match field's fixed width (15)

2.TargetStage: When checking operator: When validating export schema: At field "Column_name1": Exporting a fixed length field with a "null_field" of length 0 will prohibit a re-import of this field

3.TargetStage: When checking operator: When binding input interface field "Column_name2" to field "Column_name2": Implicit conversion from source type "int64" to result type "decimal[10,0]": Possible range limitation.

Note: Source and Target metadata are same.

please help me out with the above warnings. May Almighty God shower his Blessings and Mercies upon you.

Thanks
KSahik
Warm Regards
KShaik
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

Welcome Aboard :)
If you do a search on each and every one of the errors (use key words), you will see that they have been covered in detail before, time and again. Please use the search facility.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Post Reply