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. |