How to map data pipeline source columns to destination
columns
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.