Limitations of write operation

During the write operation, the rows in the source database are mapped and streamed into the destination database.

The columns of the source database are not mapped individually. So you cannot interchange the order of the columns while writing to the destination database. The Netezza write operator expects the column format in the destination database to be identical to the schema of the source.