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?
Decimal to Integer
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 24
- Joined: Wed Oct 17, 2007 1:28 am
- Location: hyderabad
Re: Decimal to Integer
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
ETL=DS
Re: Decimal to Integer
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?
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?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: