When you create a flat file source, note that

B2B Data Exchange

supports only the

Delimited

formatting option.

B2B Data Exchange

does not support the

Fixed Width

option.

The flat file formatting parameters are created with predefined names. These parameter values are later defined in

B2B Data Exchange

using workflow parameters and passed back to Cloud Data Integration.

You can create the following expression parameters:

Prop_SrcFormattingOpt_Delimiter
. Define a delimiter. Accepts text values as follows:
Comma
resolves to
,
which is the default setting.
Semicolon
resolves to
;
Colon
resolves to
:
Tab
resolves to
\T
Any other value is passed directly as text.
Prop_SrcFormattingOpt_TextQualifier
. Define a text qualifier. Accepts text values as follows:
Double Quote
resolves to
\"
which is the default setting.
None
resolves to
none
Single Quote
resolves to
'
Any other value is considered an error. The default value is passed instead.
Prop_SrcFormattingOpt_FirstDataRow
. Identify the first data row.
Prop_SrcFormattingOpt_ImportRow
. Import the header from a row.
Prop_SrcFormattingOpt_EscapeChar
. Defines an escape character.

For more information about Expression transformations, see

Informatica Intelligent Cloud Services Transformations Guide

.