What column order does StreamSets select from Oracle?

asked 2020-10-14 11:22:02 -0600

When using an Oracle source, and selecting all from the table, the output from the source does not match the column order shows in Oracle. This is not an issue when targetting another DB or something, but when writing to a CSV, the file is not consistent with the DB. This is an issue for us, when we are writing to S3, as part of a datalake, which is expecting the file to match the DB table.

edit retag flag offensive close merge delete