Hi Gurus,
I have a column in my source(oracle) which is of Varchar2 data type.It is a column which has two constant vaues TRUE and FALSE.
But in the target(Oracle), same column's datatype is decimal.When i tried loadingi am getting Nulls.
Please give your valuable suggestions to overcome this issue.
(Actually i tried changing the data type of the target column, but still i am not getting the out put.)
Data type from varchar2 to decimal
Moderators: chulett, rschirm, roy
There should be a field level mapping give to you. Or look into the given buisness rules. There might be some code change involved. Somting like 1--> True; 0 --> False. Use transformer to acheive this.
And dont try acheive somting new by fiting charecters into decimal field.
And dont try acheive somting new by fiting charecters into decimal field.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
It's just a simple if-then-else statement in your derivation. This is not something you've had to do before? 
The only thing that might 'complicate' the process a little is if there may be values other than TRUE or FALSE in the field, or if it might come in various cases or if it could possibly be null.
If that's the case, we'd need to know the transformation rules for those situations but it still should be very straight-forward. Why not take a shot a doing it yourself and see if you can work it out rather than waiting for someone to spoon-feed you an answer?
Post back with a more specific question if you run into a problem.
The only thing that might 'complicate' the process a little is if there may be values other than TRUE or FALSE in the field, or if it might come in various cases or if it could possibly be null.
If that's the case, we'd need to know the transformation rules for those situations but it still should be very straight-forward. Why not take a shot a doing it yourself and see if you can work it out rather than waiting for someone to spoon-feed you an answer?
Post back with a more specific question if you run into a problem.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Craig,
What I meant was just a logical head start for the poster. Dint mean to solve the problem :D
What I meant was just a logical head start for the poster. Dint mean to solve the problem :D
Very Truechulett wrote: How 'bout we let Vivek work it out from there as a learning exercise rather than pick up the spoon again?
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
