job error is :
Fatal Error: APT_Decimal::assignFromString: the source string (322665901919233341505776723281119128249 ) is out of range for the decimal with precision 38.
I am able to read the data in source only after converting it Char by using TO_Char function.
Then i using Decimal_from_String function in modify stage.
I tried by putting transformer stage also but couldn't able to resolve either by converting it as "AsInteger" and giving my target meta data as Bigint for that column.
![Sad :(](./images/smilies/icon_sad.gif)
My job design is:-
Oracle Enterprise-------------->Modify--------->Oracle Enterprise
how to change the defualt Decimal[38,10]........when i am changing the environmental variable APT_DECIMAL_INTERM_PRECISION to [42] and APT_DECIMAL_INTERM_SCALE to [2] but most probably its changing the value during the runtime, not very sure about this.
![Mad :x](./images/smilies/icon_mad.gif)
any suggestion will be of gr8 help. Thanks in advance.