Symptom
When designing a Data Pipeline, the columns of the source data source will be automatically mapped to the columns of the destination data source. Users cannot manually modify and adjust the mapping order of columns.
Environment
PowerBuilder
Cause
It’s the current design for Data Pipeline. It doesn't support editing source code of the Data Pipeline to modify the order.
Solution
There are two solutions:
-
Convert the SQL to syntax and rearrange the columns in the select for the source table, you can also add all needed columns in your SELECT list to map with the destination table. Maybe it will be easier for you to control the order, but it will not be a good solution if you don't want to update some columns in the destination table.
-
Add a database view in the destination database to control the order of the destination table. There use that view instead of a table as the destination table.
