Informatica Connector Toolkit
All Products
Property
| Value
|
---|---|
Name
| table
|
Display Name
| Table
|
Description
| Represents a MySQL table.
|
Pattern Type
| Record
|
Property
| Value
|
---|---|
Name
| tableType
|
Display Name
| Table Type
|
Description
| Represents the type of record.
|
Data Type
| String
|
Min Length
| 0
|
Max Length
| 255
|
Property
| Value
|
---|---|
Name
| isNullable
|
Display Name
| Is Nullable
|
Description
| Indicates whether the column can contain null values.
|
Data Type
| Boolean
|
Default Value
| True
|
Property
| Value
|
---|---|
Name
| ColumnDefaultValue
|
Display Name
| ColumnDefaultValue
|
Description
| Indicates the default values that the column can contain.
|
Data Type
| String
|
Min Length
| 0
|
Max Length
| 255
|
Property
| Value
|
---|---|
Name
| preSQL
|
Display Name
| Pre-SQL
|
Description
| SQL queries to run before the adapter reads data from the source.
|
Data Type
| String
|
Min Length
| 0
|
Max Length
| 255
|
Supports Parameter
| Partial Parameterization
|
Property
| Value
|
---|---|
Name
| rowLimit
|
Display Name
| Row Limit
|
Data Type
| Integer
|
Min Length
| 0
|
Max Length
| 10
|
Supports Parameter
| No
|
Options
| Override Partition
|
Property
| Value
|
---|---|
Name
| postSQL
|
Display Name
| post SQL
|
Data Type
| String
|
Min Length
| 0
|
Max Length
| 255
|
Supports Parameter
| Partial Parameterization
|
Property
| Value
|
---|---|
Name
| rowOffset
|
Display Name
| Row Offset
|
Data Type
| Integer
|
Min Length
| 0
|
Max Length
| 0
|
Supports Parameter
| Full Parameterization
|
Options
| Override Partition
|
Property
| Value
|
---|---|
Name
| truncateTargetTable
|
Display Name
| Truncate Target Table
|
Description
| Indicates whether to truncate the target table before starting the write operation.
|
Data Type
| Boolean
|
Default Value
| False
|
Property
| Value
|
---|---|
Name
| partitionID
|
Display Name
| Partition ID
|
Data Type
| String
|
Min Length
| 0
|
Max Length
| 50
|
Supports Parameter
| No
|
Override Partition
| -Override Partition
|
Updated January 10, 2019