I have imported a oracle table having following columns in an ODBC stage
Salary => NUMBER (8,2)
Commission => NUMBER (2,2)
When I executed the job, I got the following warning
" When checking operator : When validating export schema: At field "Salary" : "Null-field" length (0) must match field's fixed width (10)
When checking operator : When validating export schema: At field "Salary" : "Exporting a fixed length field with a "null-field" of length 0 will prohibit a re-import of this field"
" When checking operator : When validating export schema: At field "Commission" : "Null-field" length (0) must match field's fixed width ((4)
When checking operator : When validating export schema: At field "Commission" : "Exporting a fixed length field with a "null-field" of length 0 will prohibit a re-import of this field"
How can we suppress this error message?
ODBC Stage throwing warning message on field definition
Moderators: chulett, rschirm, roy
-
muralisankarr
- Premium Member
- Posts: 83
- Joined: Tue Oct 28, 2008 1:55 am
- Location: Chennai
ODBC Stage throwing warning message on field definition
The minute you start talking about what you're going to do if you lose, you have lost
Hi,
I believe you are capturing rejects in seq file after loading to DB.
In that case do like below
Go to columns tab of the sequential file stage click on the column number and go to the edit column meta data window and in the Nullable properties specify the null field value as equivalent no of spaces.
I believe you are capturing rejects in seq file after loading to DB.
In that case do like below
Go to columns tab of the sequential file stage click on the column number and go to the edit column meta data window and in the Nullable properties specify the null field value as equivalent no of spaces.
Thanks,
Akarsh Kapoor
Akarsh Kapoor
