AnsweredAssumed Answered

How to change field name to lower case when copying table data from Oracle to PostgreSQL?

Question asked by Dmitriy Vinokurov on Feb 6, 2018
Latest reply on Feb 8, 2018 by John Craig

I am using ETL Metadata Injection to provide table name to the template transformation as a parameter which is read from a list of names. My template transformation contains a single Table input connected to a single Table output.

Currently the transformation is failing as the column "SYSID" is quoted in the generated INSERT statement because it is a reserved word. As a result it cannot be found in the output table because in PostgreSQL the column name is lower case.

Outcomes