Amazon S3 Connector

Amazon S3 Connector

Distribution Column

Distribution Column

You can write multiple files to Amazon S3 target from a single source. 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!