User Guide : Map Connectors : Source and Target Map Connectors : DIF
Share this page             
DIF is an acronym for Data Interchange Format. DIF is a somewhat universal format and is similar to a delimited ASCII file in that it contains fields and records of data that are separated by specific field and record separators. Many applications can read or write a DIF file. Therefore, it may be used as an intermediate format when transforming data to or from applications that may not be supported "directly." With the DIF connector, you can read and write DIF data files.
Connector-Specific Notes
No known limitations.
Property Options
You can set the following source (S) and target (T) properties.
If the first data record in your source file contains column names, you can read this record and use the information as field names. The default is false. To change the setting to true, click the Value cell, highlight the default value, and type the required value.
Note:  If the Header property is set to true, the first row of data is used as field names. If the property is false and the source file contains header labels, these labels are used. If the property is false and there are no header labels, the column headings appear as Field1, Field2, and so on.
This is the number of records to examine for automatic sizing. The default is 1000.
By default, DIF vectors are written before the tuples, therefore the default is false. If you want to reverse the vectors and tuples, change this option to true.
The default text reads "created by third party conversion product." According to the DIF specifications, this property is not a table name; instead, it is a "title that describes the data." To change the default text, click the text box, and replace the original text with your own description.
Use Cr-LF
By default, this option is set to true and a carriage return-line feed is returned at the end of each line in your DIF file.
This translation table determines which encoding to use for reading and writing data. The default is ANSI, the standard in the US.
Data Types
Only two data types are available for DIF data files.