Operator Guide

Back Next

Step 5. Select and Configure Subscription Target

Select the type of the target to which

Data Integration Hub

writes data and define the location and the structure of the target file in the

Target

page of the subscription wizard.

Select the target type from the

Target Type

list.

If you select the HDFS target type, the

HDFS Connection

field appears on the page.

If you select the HDFS target type, select a connection from the

HDFS Connection

list.

To use file transfer to deliver files to remote servers, select

Use File Transfer

The

Connection

field appears on the page.

If you selected to use file transfer, select a connection from the

Connection

list.

Define the location and the structure of the target file:

Directory: Location where
Data Integration Hub
creates the target file or files.
Data Integration Hub
generates a file for each table in the topic.
Target Filename Pattern: Pattern of the names of the target files. For more information, see Target File Name Pattern for Flat Files.
Code Page: Character encoding used in the file.
Use column names as the first line: Use the first line in the source data as the table header.
Delimiter: 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
.
Text Qualifier: Optional. Symbols used in the file to enclose a string.
Thousands Separator: Optional. Symbol used in the file as a thousands separator.
Decimal Separator: Symbol used in the file as a decimal separator.
Datetime Format: 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
.
The datetime format can contain up to 50 characters.