...
In this pipeline, the TPT Delete Snap deletes the TPT table items by providing a delete query condition. The TPT Insert Snap inserts the values into the TPT records via the upstream JSON Generator Snap.
The upstream JSON Generator Snap supplies the values to be inserted into the records of the target TPT Table. The respective output preview is as displayed:
.png?version=1&modificationDate=1489648592385&cacheVersion=1&api=v2&width=450)
.png?dc=201702100931-29)
The TPT insert Snap inserts the values into the records of the TPT table Table Delete under the schema, ADW SNAPL. Additionally provide the Fetch metadata delay field with a time of 5secs to avoid the conflict of parallel TPT executions in the pipeline.
The output preview at the TPT Insert Snap is as displayed below:
The Mapper Snap maps the values to the target path, here, the value 103 is mapped to the column empno.
.png?version=1&modificationDate=1489648588187&cacheVersion=1&api=v2&width=850)
.png?dc=201702100933-54)
The TPT Delete Snap deletes the items from the table, "ADW_SNAPL"."Delete_Table item1" by providing the delete condition, empno > :empno which deletes all the items that have the empno greater than the value 103. Leave the Delete Condition field empty if the entire table needs to be deleted.
.png?dc=201702100933-24)
.png?version=1&modificationDate=1489648586954&cacheVersion=1&api=v2&width=500)
The successful execution of the pipeline displays the below output preview:
(Note that the two rows having the value greater than103 have been deleted from the table)
| Panel | ||
|---|---|---|
| ||
4.8.0
|
...