-
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..........
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|