Setting a Default Record
You can select a default record from a flat file dictionary when creating a flat file schema. This record is used to parse an undefined data record when the convertToValues service fails to find a match between the flat file and the flat file schema. In other words, Integration Server will use the default record to parse any records it does not recognize.
Keep the following in mind when deciding whether or not to set a default record:
If your flat file does not contain record identifiers, you must select a default record. By selecting a default record, a CSV (comma separated values) file can be parsed as a special case of record with no record identifier, but with fixed field and record delimiters.
If you do not select a default record, unrecognized records are placed into the output IS document with the undefined data tag, which might produce errors.
If the default record is specified when creating the flat file schema, any record that cannot be recognized will be parsed using this default record. If a default record is not selected, the record will be treated as undefined data. If the
Undefined Data property is set to
False and the validate variable of the
convertToValues service is set to true,
convertToValues will generate errors when it encounters undefined data. For more information about the
Undefined Data property, see
Allowing Undefined DataTo specify a default record
1. In the Package Navigator view of Designer, open the flat file schema to which you want to add a default record.
2. In the Properties view under the Default Record area, click 
next to Set. 3. Browse to and select the default record for this flat file schema from a flat file dictionary, then click Next.
4. Select the record definition to use as the default record, then click Finish.
5. Save the flat file schema.
