File List Connector > Schema and Custom Header File > Schema File
  

Schema File

You can define the schema for a File List connection that you want to import as a source or target object in Data Integration. You can use schema file to optimize the functionality of File List Connector.
File List Connector uses the schema file to determine the start and end of a column or data types in fixed-width and delimited files.
The following image shows a sample schema file present in the <Secure Agent installation directory>\apps\Data_Integration_Server\ext\deploy_to_main\tomcat\plugins\<plugin ID> directory:
The following table describes the properties of the schema file:
Property
Description
FILEWIDTH
Enter the required width to generate a fixed-width file.
ISFILTERABLE
Enter Y or N accordingly to the requirement.
DATATYPE
Enter required data type.
File List Connector supports the following data types:
  • - Integer
  • - Decimal
  • - String
  • - Boolean
  • - Datetime
  • - Date
  • - Double
  • - Float
  • - Binary
  • - Short
  • - Long
  • - Bigint
PRECISION
Enter the required precision value.
SCALE
Enter the required scale value.
FLD_DISPLAY_NAME
Enter the required field display name.
This name appears when you select the Display technical names instead of labels option in data preview.
The following image shows an example of field display name:
In this figure Col1 and Col2 are the FLD_DISPLAY_NAME values.
FLD_NAME
Enter the required field name.
The name appears when you do not select the Display technical names instead of labels option in data preview.
FLD_DESCRIPTION
Schema file do not support FLD_DESCRIPTION field.