12.2.2 Data Tab

The following table describes the information you must provide in the Data tab when creating an EDD.

Note:

Fields marked in red asterisk (*) are mandatory

Table 12-1 Data Tab Description

Fields	Description
Data File Name	You can add multiple data files to an EDD. For example, if you need to add the Term Deposits Contracts data file. There are Term Deposits Contracts data files for retail as well as corporate accounts. Therefore, to get both these details, you first add the Term Deposits Contracts data file for retail accounts, such as td_contracts%#MISDATE%_1.csv, and as the next record, add the Term Deposits Contracts data file for corporate accounts. In case the file sizes are large, it is recommended you break the file into smaller files. Optimize file size is 3 GB for each file. Example: td_contracts%#MISDATE%_1.csv
Record Delimiter	The records are stored differently in different operating systems. The available options are: MS-DOS Unix No Record Delimiter Other For example, select Unix.
File Format	There are two options: Fixed Length: The file has records and columns with a fixed length. Each column has a predetermined and unchanging size, set when the record layout is designed, and the sum of the column sizes add up to the record size. Delimited: There is a separation of the records and columns using a delimiter character like a comma, semicolon, hyphen, and so on. For example, select Delimited.
Text Qualifier	A character that identifies text. Generally, double quotes are prefixed and suffixed to identify text. This is optional.
Skip Number Of Records	Provide the number of records to be skipped. The records are skipped from the top. Generally, this is used to skip headers.
Decimal Separator	The character used to identify the decimal and fractional part. Usually point (.) or comma (,)
Read from template	Specify if you want to use a template containing all values in the Excel file format. If the template is not available, create it manually by clicking Add, under the Data Elements. If the template is available, you can browse for the template. See the File EDD Template. You can also drop the template in the area “Drop template here or click to select “.
Select Template (*.xls,*.xlsx,*.csv Files Only)	Click Browse and select the required template.
Data Elements
Name	Name of the field in EDD. Example: Field name in a file or column name in a table. Note: The Field name of XML type must not be more than 25 characters and for others must not be more than 30 characters.
Type	This shows the Data type. Example: String, Number, Date, EBCDIC, and so on.
Length	This is applicable only for the EBCDIC format. This is the length of the EBCDIC data type. In the case of a file, it is length only.
Precision	This is used to specify the number of digits after the decimal point. Example: 10.3.
Format	Specify the format for columns of type date here. If left blank, a default format of DD/MM/YYYY is assumed and used. Note: The default format is fixed and does not change with database or system language settings. For data ingestion, enter the format in which date fields are provided. For data extraction, enter the format in which extracted date fields must be recorded. For example, in the file extract, to represent the date, 31st January 2020, as “31/01/2020”, specify the format as DD/MM/YYYY for the date columns.
Record Type Code	This identifies the Record type in a file where Header, Trailer, and Data are of different record length and type. The values can be any string available in the text file. This value is only possible for the first field in a file. Example: The values can be DATA; CTRL to specify it is a control record.