Hi, I'm Ask INFA!
What would you like to know?
ASK INFAPreview
Please to access Ask INFA.
You were redirected to the closest matching page. If this looks correct, please consider bookmarking it for future reference.
Not Found
English

Page Not Found

The page or file you are looking for has been moved or no longer exists.

The following links might help you find the content you need:


You can also search the Documentation Portal or visit the home page.

English
  • Data Integration Connectors
  • All Products

Table of Contents

Search

  1. Introduction to Amazon S3 V2 Connector
  2. Amazon S3 V2 connections
  3. Amazon S3 V2 sources and targets
  4. Mappings and mapping tasks with Amazon S3 V2
  5. Migrating a mapping
  6. Upgrading to Amazon S3 V2 Connector
  7. Data type reference
  8. Troubleshooting

Amazon S3 V2 Connector

Amazon S3 V2 Connector

Back Next

Distribution column

Distribution column

You can write multiple flat files to Amazon S3 target from a single source in a mapping. Configure the
Distribution Column
 option in the advanced target properties.
You can specify one column name in the
Distribution Column
 field to create multiple target files during run time. When you specify the column name, the Secure Agent creates multiple target files in the column based on the column values that you specify in
Distribution Column
.
Each target file name is appended with the
Distribution Column
 value in the following format: 
<Target_fileName>+_+<Distribution column value>+<file extension>
Each target file contains all the columns of the table including the column that you specify in the
Distribution Column
 field.
For example, the name of the target file is
Region.csv
 that contains the values North America and South America. The following target files are created based on the values in the
Distribution Column
 field: 
Region_North America.csv
Region_South America.csv
You cannot specify two column names in the
Distribution Column
 field. If you specify a column name that is not present in target field column, the task fails.
When you specify a column that contains value with special characters in the
Distribution Column
 field, the Secure Agent fails to create target file if the corresponding Operating System do not support the special characters.
For example, the Secure Agent fails to create target file if the column contains date value in the following format:
YYYY/MM/DD
0 COMMENTS
We’d like to hear from you!