NULL Handling

[cosec]

When Loading From a Fixed Width Sequential File (Space between columns =1 ) how to handle null values....do I have to validate every column ? for eg

In the transformer for date column and timestamp column I have a validation such as = If trim(Arg1)="" then @null else iconv(trim(arg1))

Is there better way to handle the nulls ?

In one of the integer columns when the value is blank and it's loaded to nullable Column I get a warning saying that the string cannot be converted and is a null.....how can i avoid the warning ?

Pls help



If the Date is NUll
Timestamp

[chulett]

Basically answered in your other thread. Yes, if your data is problematic then you could need to validate / cleanse each and every field.