FileName is a reserved keyword. Avoid using FileName as the column name in the source data. The name is case sensitive.

Do not map the source object FileName field to the target object FileName field for a complex file. If you map the FileName field in the target object to an incoming field, the Secure Agent does not create directory structure as expected.

When you use the FileName field in a target object, the Secure Agent creates folders with different names for null values for mappings in advanced mode:

For mappings, the target file name is appended with
_EMPTY_
.
For mappings in advanced mode, the target file name is appended with
_HIVE_DEFAULT_PARTITION_

When you map a date type incoming field to the FileName field in the target object, the Secure Agent creates a nested folder structure based on the incoming date value for target objects.

When you map an incoming field to the FileName field in the target object and the target has the

Handle Special Characters

option enabled or the target file name has special characters, the mapping fails with the following error on a Windows machine:

When you map an incoming field to the FileName field in the target object, the mapping runs successfully for the first time. At subsequent runs, the mapping fails with the following error:

When you create a target at runtime, the target file name is not generated in the expected format.

When you write data to an existing target object or create a new target object with a partition directory, the FileName field is not added on the target side. The FileName field is only present at the source side.