Converting Decimal to Integer in Transformer Stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Rajesekhar
Participant
Posts: 19
Joined: Fri May 14, 2010 3:54 pm

Converting Decimal to Integer in Transformer Stage

Post by Rajesekhar »

hi,

I have a requirement to convert Decimal to Integer in Transformer Stage.

could any one help me how can I do this? Is there any function to perform the same?

-Thanks,
Raj.
Rajesekhar Potteti
anbu
Premium Member
Premium Member
Posts: 596
Joined: Sat Feb 18, 2006 2:25 am
Location: india

Post by anbu »

map decimal directly to an integer field in target
You are the creator of your destiny - Swami Vivekananda
Rajesekhar
Participant
Posts: 19
Joined: Fri May 14, 2010 3:54 pm

Post by Rajesekhar »

anbu wrote:map decimal directly to an integer field in target
What exactly happens when I map directly decimal to integer. Is it rounding off the values or truncating the precision part?

thanks for the response.
Rajesekhar Potteti
anbu
Premium Member
Premium Member
Posts: 596
Joined: Sat Feb 18, 2006 2:25 am
Location: india

Post by anbu »

Rounding.

Use AsInteger to truncate decimal numbers
You are the creator of your destiny - Swami Vivekananda
Post Reply