Is it possible to use SQLLoader to transform data from one field, based on a rule, then insert into another column.

For example, I have a column called Mortgage_Balance and a column called Mortgage_Class.

If the data in the input file for Mortgage_Balance is between 0 and 9999, then I want to populate Mortgage_Balance with the raw data AND Mortgage_Class with the value 'A'.

If the data in the input file for Mortgage_Balance is between 10000 and 19999, then I want to populate Mortgage_Balance with the raw data AND Mortgage_Class with the value 'B'. etc.......

I haven't got a Scooby Do how to do this..........