Collect
Description
The Collect uses a given expression to select the start keys for your start table. These start keys are used in the Extract.
Input parameters
| Parameter | Description |
|---|---|
startTable |
The start table, where the start keys get selected. |
expressionFile |
File containing a WHERE clause for limiting the start keys that should be selected. |
outputFileName |
The name of the csv file where the keys should be written. |
objectContainerPath |
The path of the source object container. |
url |
The url of the source system. |
databaseType |
This property controls witch database type the target database is. Possible values are: "DB2_LUW", "ORACLE", "DB2_ZOS", "MS_SQL_SERVER" or "POSTGRESQL". |
user |
The database user. |
password |
The user’s password. |
rowSelectionMode |
Here you can define how the start keys get collected. It is possible to set the selection mode to: |
"FILE", "NUMROWS", "PERCENTAGE" or "QUERY". "File" means that you can pre-define values as your start keys. "NUMROWS" defines for how many rows start keys should be selected. |
"PERCENTAGE" defines how many percent of the selected start keys should be collected. "QUERY" uses an SQL expression to select the start keys. Default: QUERY |
useEncryptedPassword |
Shows if the given password has to be decrypted. Default: true |
classificationTermKeyFile |
The JSON file that contains the classification term keys. |