Page 1 of 1
Decimal to Integer
Posted: Fri Nov 02, 2007 1:20 am
by dashpriya
Hi,
Any one can plz help me to do a filed conversion.
My source is EEDBPE (Decimal(15)).I want it to map to the filed TRAN_AWRD_CNT (Integer(10)).
Can any one give me any sujjestion wether I need to validate the source filed to IsValid('INT32',EEDBPE) or will I do direct mapping?
Re: Decimal to Integer
Posted: Fri Nov 02, 2007 1:51 am
by sanath1234
dashpriya wrote:Hi,
Any one can plz help me to do a filed conversion.
My source is EEDBPE (Decimal(15)).I want it to map to the filed TRAN_AWRD_CNT (Integer(10)).
Can any one give me any sujjestion wether I need to validate the source filed to IsValid('INT32',EEDBPE) or will I do direct mapping?
use modify stage
Re: Decimal to Integer
Posted: Fri Nov 02, 2007 2:12 am
by dashpriya
I need a type conversion.So for one field I donot want to use ant stage.Can i use any logic like if the source vaue is of some particular range(as per decimal range) then how can I map it to target which is Integer(10).?
My question is can i take some upper bound and lower bound facility and can i map it directly by using some intermediary logc in transformer?
Posted: Fri Nov 02, 2007 4:22 am
by ray.wurlod
Of course you can. You will also need a specification, and therefore some logic, to define what happens with any out-of-range values.
Posted: Fri Nov 02, 2007 9:32 am
by gbusson
Hi,
Decimal(15) to BigInt is automatic.
it may be useful.