Hello mj.redfox.mj (AT) gmail (DOT) com,
Quote:
I have a data pump task which uses a csv file as the source, and a db
table as the destination. I have set up transformations to map the
fields in the source to the destination.
However...if the order of the columns in the csv file is now shuffled,
but the names of the re-ordered columns are still kept the same (but
obviously just in a different order), would my data pump task still
work, or would the fact that the columns are now in a different order
mean that my transformations would need to be redone?
Thanks folks! |
if the header of your file contains column names you shoudn't have problems,
even if columns are reordered (of course in file connection props you need
to check 'First row has column names').
Bye