Hi,

I need to transform the value in source columns by
translating the last character in the string to the
appropriate number. Main Frame uses a alpha numeric value
at the end of each number to represent the sign and the
ending digit. There are 30 such columns in the source
text file and I thought a Look up would be faster instead
of 30 update statements.

When I use the Lookup option on the Data Pump task
properties I get 'Server not configured for Data Access'
error.

Could someone please help me with this?

Thank you for your time.

Regards,
Jyothi