currency conversion

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
sreekanth kutumbaka
Participant
Posts: 16
Joined: Wed May 31, 2006 10:57 pm
Location: Hyderabad

currency conversion

Post by sreekanth kutumbaka »

i want to design a mapping for corrency conversion
based on a date. the following are the inputs.

Note: assume TOdays doller rate Rs 47.

Date| From currency| tocurrency| amount to be converted
2006/07/10| Rupee Rs| US $ | 1000

here my issue is how to convert indian rupee to US $ and $ is varying every day .and also how to write sub routine for this currency conversion

Note : The conversion rate to be used for writing the mathematical formula above is get from lookup table (every Day $ rate)

any body lead me

cheers
sreekanth
Sreekanth
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

You need to post in the correct forum. Also, this question is on the same lines as your other question. Please refer to Ken's reply in your other post.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Do you HAVE the lookup table? How will it be maintained? For example, XE.com have a data feed service available.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply