I am using the when clause with multiple AND conditions. I need to use an OR condition to check if either of two fields are not blank and load data based on it.
eg. WHEN ITEM != ' ' OR SUB_ITEM != ' '
The sqlloader doesn't like the OR condition and I get an error, is the OR condition supported ?
Is there some other work around to this problem.