Hi, I'm Ask INFA!
What would you like to know?
ASK INFAPreview
Please to access Bolo.

Table of Contents

Search

  1. Connectors and connections
  2. Connection configuration
  3. Connection properties
  4. Swagger file generation for REST V2 connections

Connections

Connections

File List connection properties

File List connection properties

When you set up a File List connection, you must configure the connection properties.
The following table describes the File List connection properties:
Connection property
Description
Connection Name
Enter a unique name for the connection.
Description
Provide a description for the connection.
Type
Select File List from the list.
Secure Agent
Select the Secure Agent from the list.
File Type
Select the file format from the list. The connection supports fixed-width and delimiter file types.
Delimiter
Select the delimiter. The default delimiter is Comma.
Schema File Path
Specify the schema file path. A sample schema file is present in Informatica Secure Agent folder. The path is
<Secure Agent installation directory>\apps\Data_Integration_Server\ext\deploy_to_main\tomcat\plugins\<plugin ID>
Custom Header File Path
Specify the header file path. You can find
header.hdr
file in Informatica Secure Agent folder. The path is
<Secure Agent installation directory>\apps\Data_Integration_Server\ext\deploy_to_main\tomcat\plugins\<plugin ID>
Skip First N lines
Specify the number of rows you want to skip while merging the files. This helps you to skip the rows from the beginning of the file.
Skip Last N lines
Specify the number of rows you want to skip while merging the files. This helps you to skip the rows from the end of the file.
Merge File Path
It is the file which contains details of all the multiple files you need to merge using the File List Connector.
Provide the path where this file resides. The following image shows a sample of merge file path where file1 and file 2 are the two files to be merged:
Rows Per Batch
Mention the required batch size to optimize the performance. The default value is 100.
Date Format
Mention the Date format. The default date format is dd-MM-yyyy HH:mm:ss.

0 COMMENTS

We’d like to hear from you!