Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange for Amazon Redshift
  3. PowerExchange for Amazon Redshift Configuration
  4. Amazon Redshift Connections
  5. PowerExchange for Amazon Redshift Data Objects
  6. Amazon Redshift Mappings
  7. Pushdown Optimization
  8. Amazon Redshift Lookup
  9. Appendix A: Amazon Redshift Datatype Reference
  10. Appendix B: Troubleshooting

PowerExchange for Amazon Redshift User Guide

PowerExchange for Amazon Redshift User Guide

Target Schema Strategy

Target Schema Strategy

You can choose to retain an existing target table or create a new target table in the target when you run a dynamic mapping.
You can select one of the following options in the
Target Schema Strategy
advanced properties for the data object write operation:
RETAIN - Retain existing target schema
The Data Integration Service retains the existing target schema.
When you select
RETAIN
option and if the target table does not exist or the metadata of the source and target tables do not match, the mapping fails.
CREATE - Create or replace table at run time
The Data Integration Service creates a new table based on the data object or the mapping flow if the table does not exist in the target.
When the Data Integration Service creates a table based on the data object, the table contains columns that match the ports in the data object. When the Data Integration Service creates a table based on the mapping flow, the table contains columns that match generated ports in the Write transformation.
When you select
CREATE
option and if the table already exists in the target, the mapping fails with an error message stating that the target table already exists.
Assign Parameter
You can assign a parameter to represent the value for the target schema strategy and then change the parameter at run time.

0 COMMENTS

We’d like to hear from you!