General Tab (DB Definition)

Fields

Field Name	Description
DB Connections	Select the DB Connections used on this File Definition. This is a design time setting, and can be overridden with run time setting on the Action.
Transaction Identification	Select the method to use for flagging transactions as processed. This only applies when the DB Definition is used as the source of a Map (exporting data).
Duplicate Record Handling	Select the method to handle duplicate records when importing data. This only applies when the DB Definition is used as the destination of a map (importing data).
Use In-Memory Check	Select to enable the Duplicate Record Handling check to be performed in memory rather than via individual SQL statements.
Disable automatic string trim	Disable the automatic trimming of blank spaces from the start and end of strings.
Save Null Fields as Blank String	Enables generated SQL statements to use blank strings for any fields with null values. This only applies when the DB Definition is used as the destination of a map (importing data).
Save Blank String Fields as Null	Treats fields with blank string values as nulls. This works with Include null values in SQL Statements. This only applies when the DB Definition is used as the destination of a map (importing data).
Include null values in SQL Statements	Enables generated SQL statements to include null values for any fields with null values. This only applies when the DB Definition is used as the destination of a map (importing data).