Hi All,
I am trying to load one Flat file toNetezza database. In flat file, I have a column as Varchar and in Target the datatype of column is Integer.
I am not using any function for explicit conversion in between. Now if I have data as 1234, it gets loaded correctly. But when I have data like 'abc', it inserts '0'.
Should not that record be rejected because of datatype issue?
The message I am geeting in log file is :
"Transformer_1,1: Numeric string expected for input column 'A'. Use default value."
Is there a way to get that record rejected in case of 'abc' and capture it in a file?
Thanks.
String to Integer Conversion
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: