Transformations > Source Transformation > File Source Properties
  

File Source Properties

You can configure properties for file sources, such as flat file and FTP/SFTP.
The following table describes the file source properties:
File Property
Description
Connection
Name of the source connection.
Source Type
Source type. The source type can be single object, file list, command, or parameter.
Object
If the source type is a single object, this property specifies the file source, for example, Customers.csv.
If the source property is a file list, this property specifies the text file that contains the file list, for example, SourceList.txt.
Sample Object
If the source type is a command, this property specifies the sample file from which Informatica Cloud imports the source fields.
Command
If the source type is a command, this property specifies the command that generates the source file list, for example, ItemSourcesCmd.bat.
Parameter
If the source type is a parameter, this property specifies the source parameter.
Formatting Options
Flat file format options. Opens the Formatting Options dialog box to define the format of the file.
You can choose either a delimited or fixed-width file type. Default is delimited.
For a delimited flat file type, configure the following file format options:
  • - Delimiter. Delimiter character.
  • - Text Qualifier. Character to qualify text.
  • - Escape character. Escape character.
  • - Field labels. Determines if the task generates field labels or imports labels from the source file.
  • - First data row. The first row of data. The task starts the read at the row number that you enter.
For a fixed-width flat file type, select the fixed-width file format to use. If you do not have a fixed-width file format, go to Configure > Fixed Width File Formats to create one.
For more information about file formats, file lists, commands, and parameters, see Design.