special characters in column names

lfong · Post by **lfong** » Tue Mar 13, 2007 1:42 pm

I am working with version 8 and have the following problem with Oracle column names.
My source has column names with '$'(CLAIMED$), #(phone#). When importing the definitions, the # gets changed to _036_, the # _035_.
Can I fix this rednaming the colums using the modify stage. If so, would I use the _036_ or the '$' as the old_columnname.

Thanks

ray.wurlod · Post by **ray.wurlod** » Tue Mar 13, 2007 6:09 pm

There is a specific section in the Parallel Job Developer's Guide (page 12-6)