If you want to overwrite the parameter at runtime, select the

Allow parameter to be overridden at run time

option when you create a parameter. When the task runs, the agent uses the parameters from the file that you specify in the task advanced session properties.

You can select an existing object or create an object at runtime. When you create an object at runtime, enter a name and the path for the target object.

If you want to overwrite the parameter at runtime, select the

Allow parameter to be overridden at run time

option when you create a parameter. When the task runs, the agent uses the parameters from the file that you specify in the task advanced session properties.

Enter a name and path for the target object. You can use parameters defined in a parameter file in the target name.

For more information, see Rules and guidelines for creating a target.

You can select the following file format types:

None
1
Flat
Avro
ORC
Parquet
JSON
2
Delta
1

Default is

None

. If you select

None

is as the format type, the Secure Agent writes data to Amazon S3 files in binary format.

For more information about format options, see File formatting options.

You can perform only insert operation on an Amazon S3 V2 target.

Default is true. For more information about overwriting the existing files, see Overwriting existing files.

If applicable, include the folder name that contains the target file in the

<bucket_name>/<folder_name>

format.

If you do not provide the bucket name and specify the folder path starting with a slash (/) in the

/<folder_name>

format, the folder path appends with the folder path that you specified in the connection properties.

For example, if you specify the

/<dir2>

folder path in this property and

<my_bucket1>/<dir1>

folder path in the connection property, the folder path appends with the folder path that you specified in the connection properties in

<my_bucket1>/<dir1>/<dir2>

format.

If you specify the

<my_bucket1>/<dir1>

folder path in the connection property and

<my_bucket2>/<dir2>

folder path in this property, the Secure Agent writes the file in the

<my_bucket2>/<dir2>

folder path that you specify in this property.

Select one of the following encryption types:

None
Client Side Encryption
1
Server Side Encryption
Server Side Encryption with KMS
Informatica Encryption

Default is

None

.

For more information about the encryption type, see Data encryption in Amazon S3 V2 targets.

Ensure that the user has write permissions on the directory. In addition, ensure that there is sufficient space to enable staging of the entire file. Default staging directory is the

/temp

directory on the machine that hosts the Secure Agent.

When you specify the directory path, the Secure Agent create folders depending on the number of partitions that you specify in the following format:

InfaS3Staging<00/11><timestamp>_<partition number>

where, 00 represents read operation and 11 represents write operation.

For example,

InfaS3Staging000703115851268912800_0

The temporary files are created within the new directory.

The staging directory target property does not apply to Avro, ORC, Parquet, and Delta files.

You can compress the data in the following formats:

None
Bzip2
2
Deflate
Gzip
Lzo
Snappy
Zlib

For more information about the compression format, see Data compression in Amazon S3 V2 sources and targets.

You can either enter the key value pairs or specify the file path that contains the key value pairs.

Use this property when you run a mapping to write a file of flat format type. For more information about the object tags, see Object tag.

This property applies only to flat files.

Default is 10. Use this property when you run a mapping to write a file of flat format type.

Amazon S3 V2 Connector uses the

AWS TransferManager API

to upload a large object in multiple parts to Amazon S3.

When the file size is more than 5 MB, you can configure multipart upload to upload object in multiple parts in parallel. If you set the value of

TransferManager Thread Pool Size

to greater than 50, the value reverts to 50.

This property applies only to flat files.

This property applies only to flat files.

Default is 900 seconds.

If you require more than 900 seconds, you can set the time duration maximum up to 12 hours in the AWS console and then enter the same time duration in this property.

Default is 5 MB. Use this property when you run a mapping to write a file of flat format type.

This property applies only to flat files.