Property | Use |
|---|---|
CommitFrequency | Allows you to control how often data is committed to the database when the AutoCommit property is set to False. The default value is zero that is, the data is committed at the end of the transformation, allowing rollback on error. This is the slowest setting. When performing large transformations, this is not practical as it may produce too many transaction log entries. Specifying a nonzero value indicates that data is committed to the database after inserting or updating specified number of records. |
ConstraintDDL | This is a pass-through mechanism that allows you to specify any additional data definition language (DDL) statements that need to be executed when a new table is created. DDL is used to define keys, indexes, constraints and integrity rules for SQL databases. There is no default. |
Encoding | Type of encoding to use with source and target files. Default is OEM. For choices, see Source and Target Map Connectors. Notes: • Shift-JIS encoding is meaningful only in Japanese operating systems. • The Encoding property is not the encoding of the database that you connect to, but rather the encoding in which the connector expects to receive SQL query statements to be sent to the database. |
IdentityInsert | Determines if the integration platform automatically inserts Identity fields into your database. The default is false. If you want to allow Identity fields, you must change this property to true. |
SystemTables | If set to true, this property allows you to see all tables created by the DBA in the database. The system table names appear in the table list. Default is false. |