There is a column in a DB table which has a German name. When I use the tOracleInput component & click on the 'Guess Schema' button then the special characters in the German name is replaced by '_'. I have tried using UTF-8 & UTF-16 encoding schemes however no luck. Can somebody plz help
Encoding is for content data, not for field names which must be compliant with Java namming rules.
If you have a column name in the db which is not compliant with these rules, you can assign a specific name for the schema in the tOracleInput.
If you prefer you can also use SQL aliases in your query to change the column names if necessary:
select yourDbColumnName as yourSchemaFieldName from yourTable