In this page:
DeltaBased Parameter
...
- ALWAYS (default) - always rewrite the last run date value after delta-based extraction
- NEVER - switches off rewriting last run date
- ONLY_DATA_EXTRACTED - changes last run date only if some data has been extracted
Example: Delta Based Filter with increaselastrundatetime
| Code Block |
|---|
|
<taskParameter>
<name>DeltaBased</name>
<dataType>S</dataType>
<value>Y</value>
</taskParameter>
<taskParameter>
<name>increaselastrundatetime</name>
<dataType>S</dataType>
<value>ONLY_DATA_EXTRACTED</value>
</taskParameter> |
UseInstance Parameter
Toggles instance usage by resolving vDeltaDBInstance - primary key of the DB table - in extract_delta_based_param.inc
| Code Block |
|---|
|
<taskParameter>
<name>UseInstance</name>
<dataType>S</dataType>
<value>Y</value>
</taskParameter> |
...
