If you right-click on a Source transformation directly to create an Amazon S3 target, the Data Integration Service fails to create an Amazon S3 target with the following error message:

Cannot create a AmazonS3 because the transformation contains a port with the name FileName. FileName is a reserved word in the data object.

You must specify a connection for the newly created Amazon S3 target in the

Connection

field to run a mapping.

When you write an Avro or Parquet file using the

Create Target

option, you cannot provide a Null data type.

When you select a flat resource format that contains different data types and select the

Create Target

option to create an Amazon S3 target, the Data Integration Service creates string ports for all the data types with a precision of 256 characters.

When you select a flat resource format to create an Amazon S3 target, the Data Integration Service maps all the data types in the source file to the String data type in the target file. You must manually map the data types in the source and target files.

For a newly created Amazon S3 target, the Data Integration Service considers the value of the folder path that you specify in the

Folder Path

connection property and file name from the

Native Name

property in the Amazon S3 data object details.

When you use a flat resource format to create a target, the Data Integration Service considers the following values for the formatting options:

Formatting Options	Values
Delimiters	Comma (,)
Text Qualifier	No quotes
Import Column Names From First Line	Generates header
Row Delimiter	Backslash with a character n (\n)
Escape Character	Empty