Type of subscription target.

Applicable for a flat file target.

Use file transfer to deliver files to remote servers that reside outside the

Data Integration Hub

network.

Data Integration Hub

supports the FTP, SFTP, and FTPS protocols for file transfer.

Applicable for a flat file target.

Name of the file transfer connection to where the subscription workflow writes the files that the subscription consumes.

Applicable for an HDFS target. Select the HDFS connection to where the subscription workflow writes the files that the subscription consumes.

Location where

Data Integration Hub

creates the target file or files.

Data Integration Hub

generates a file for each table in the topic.

Pattern of the names of the target files. For more information, see Target File Name Pattern for Flat Files.

Character encoding used in the file.

Use the first line in the source data as the table header.

Delimiter used in the file to separate between columns. Select a predefined delimiter or select

Custom

and then define a custom delimiter. For information about the supported column delimiters, see the sections about delimited files in the

PowerCenter Designer Guide

.

Optional. Symbols used in the file to enclose a string.

Optional. Symbol used in the file as a thousands separator.

Symbol used in the file as a decimal separator.

Date and time format used in the file. Select a predefined format or select

Other

to define a custom format. For information about the supported datetime formats, see the chapter about dates in the

PowerCenter Transformation Language Reference

.