Our source, a base view with the following SQL:
ID*10+2 AS EDIT_ID,
We want to write some of its columns to two tables, and use the mapping to link certain columns
The first exporter is to a table with the following columns:
This gives the error:* "Group0#JDBCExporter0: Invalid column name 'EDIT_ID'."*
The second exporter writes to an identical table but with the a parameter mapping to convert the EDIT_ID from the base view to the column ID in the table.
This gives the error: *"Group0#JDBCExporter1: The column name 'ID' is specified more than once in the SET clause or column list of an INSERT. A column cannot be assigned more than one value in the same clause. Modify the clause to make sure that a column is updated only once. If this statement updates or inserts columns into a view, column aliasing can conceal the duplication in your code."*
Do we have to manually map all the 130 columns and set Export only mapped attributes = true to get this to work?
What is the purpose of the "***Export only mapped attributes: false***" option, if Denodo does not map columns by name automatically?
Is there a way to roll back all exporters in a job, when one fails?