In the Native environment, use the Sorter transformation to sort the source port that you want to map to the FileName port of the Target transformation. After you sort the source port, map the port of the Sorter transformation to the FileName port of the Target transformation. The Data Integration Service creates only one file for each value with the same name. If you do not use the Sorter transformation, the Data Integration Service creates multiple files for each value with the same name.

For example, create a mapping in the Native environment or on the Spark engine to read or write an Avro file using the FileName port.

The following image shows the sorter transformation mapping:

If you want to Map the following source port name to the FileName port of the Target transformation and write the data to an Avro target file

target1

:

Name	ID	SSN
Anna	1	1
John	4	4
Smith	4	4
John	5	5
Anna	2	2

Add a Sorter transformation to sort the source port and map the source port to the port of the Sorter transformation. Then, map the port of the Sorter transformation to the FileName port of the Target transformation. The Data Integration Service creates the following directories and single file per thread within the directories:

target1.avro=Anna

In this directory, the Data Integration Service creates a file with the following values:

1,1,1,2,2,2

.

In this directory, the Data Integration Service creates a file with the following values:

4,4,4,5,5,5

.

target1.avro=Smith

In this directory, the Data Integration Service creates a file with the following values:

4,4,4

.

If you do not add a Sorter transformation, the Data Integration Service creates the following directories and multiple files within the directories:

target1.avro=Anna

In this directory, the Data Integration Service creates two part files with the following values:

1,1,1

and

2,2,2

.

target1.avro=John

In this directory, the Data Integration Service creates two files with the following values:

4,4,4

and

5,5,5

.

target1.avro=Smith

In this directory, the Data Integration Service creates one file with the following values:

4,4,4

.