Template Parameters
This page describes the most frequent parameters available in the Properties view for the different types of templates available in Semarchy xDI:
Load Template Parameters
Property |
Default Value |
Description |
Cdc Subscriber |
empty |
|
Cdc Wait Mode |
empty |
|
Cdc Wait Poll Interval |
empty |
|
Cdc Wait Rows Number |
empty |
|
Cdc Wait Timeout |
empty |
|
Clean Temporary Objects |
True |
Select this option to delete the temporary objects created during a data load at the end of the process. |
Lock Cdc Table |
True |
|
Transaction Name |
T1 |
Defines the name of transactions if Use Transation On Work Tables is selected. |
Use Transaction On Work Tables |
False |
|
Unlock Cdc Table |
True |
|
Use Distinct |
False |
Select this option to add a |
Stage Template Parameters
Property |
Default Value |
Description |
Cdc Subscriber |
empty |
|
Lock Cdc Table |
True |
|
Unlock Cdc Table |
True |
|
Use Distinct |
False |
If selected, a |
Integration Template Parameters
Property |
Default Value |
Description |
Append Mode |
False |
If selected, all rows are directly inserted in the target table. No updates are performed. |
Clean Temporary Objects |
True |
Select this option to delete the temporary objects created during integration at the end the process. |
Commit Transaction |
True |
If this option is selected, transactions are committed at the end of integration. This parameter applies only if Transactional Mode On Target is selected. |
Create Index On Pre Integration Table |
True |
If selected, an index is created on the update key of the integration table to optimize the subsequent statements using this table. |
Create Target Table |
True |
Defines whether the target table must be created before integration.
|
Delete All Target Table |
False |
Replaced by Deletion Strategy. If this option is selected, all existing rows in the target table are deleted before the integration. |
Deletion Strategy |
disable |
Defines the deletion strategy for the target table:
If no column is tagged with |
Deletion Where Clause |
1=1 |
If Deletion Strategy is set to where clause, this parameter defines the |
Do Insert |
True |
If selected, insertions are performed in the target table. This parameter has no effect if Integration Strategy is set to slowlyChangingDimension. |
Do Update |
True |
If selected, existing rows in the target table are updated with new values. This parameter has no effect if Integration Strategy is set to slowlyChangingDimension. |
Recycle Rejects |
False |
If selected, rejects created during the previous execution are inserted in the integration table. |
Load |
True |
Defines whether the load step must be exectuted prior to integration. Unselect this option to disable the load step. |
Incremental Method |
insertUpdate |
Defines the method used if Integration Strategy is set to Incremental:
|
Integration Strategy |
auto |
Defines how data is integrated in the target table:
|
SCD Default End Date |
NULL |
If Integration Strategy is set to slowlyChangingDimension, this parameter defines the SQL expression used during insertions to populate the unmapped columns configured with Slowly Changing DimensionMode=endDate. |
Transactional Mode On Target |
False |
|
Transaction Name |
T1 |
Defines the name of transactions if Transactional Mode On Target is selected. |
Synchronize Deletions From CDC |
False |
If selected, rows deleted from source tables configured with CDC are deleted from the target table. |
Use Distinct |
False |
If selected, a |
Useless Update Detection Method |
flag |
Defines how pre-integration data and data from the target table are compared to identify changes:
|
Reject Template Parameters
Property |
Default Value |
Description |
Drop Reject Table |
False |
Select to drop and re-create the reject table before each execution. |
Create Index On Reject Table |
False |
Select this option to create an index on the reject table for each primary and alternate key. |
Delete Previous Rejects |
True |
Select to delete all rejects rows from previous executions at the beginning of each flow execution. |
Delete Rejects On Checked Table |
True |
If this option is selected, rejected rows will not be inserted in the target table and will be inserted in the rejected table only. This option applies only if the constraint’s Severity Level is |
Create Index On Checked Table |
False |
Select this option to create an index on the checked table for each primary and alternate key. |
Transactional Mode On Reject Table |
False |
|
Transaction Name |
T1 |
Defines the name of transactions if Transactional Mode is selected. |