pfx-api:truncate, pfx:dmTruncate - Truncate Data in Datamart
This component is used to truncate a specified Datamart, Data Source or Data Feed object in PriceAnalyzer (rundataload:TRUNCATE
).
Attributes | Description | Required by pfx:dmTruncate | Required by pfx-api:truncate |
---|---|---|---|
| ID of the component used for the route name | yes | not available |
| Name of Datamart, Data Source or Data Feed | yes | yes |
| There can be more than one targetName with the same name – then typedId is needed to guarantee that we call the correct targetName. | no | no |
| Value with an incremental date | no | no |
| You can define a filter and all the rows matched by the filter criteria will be deleted. | no | no |
Â
Example of use in camel-context.xml:
<to uri="pfx-api:truncate?targetName=DMF.Prices"/>
<to uri="pfx-api:truncate?targetName=DMDS.Prices"/>
<to uri="pfx-api:truncate?targetName=DMDS.Prices&typedId=692.DMDL"/>
<to uri="pfx-api:truncate?targetName=DMDS.Prices&typedId=692.DMDL&incrementalDate=2019-01-28T11:30:00"/>
<to uri="pfx-api:truncate?targetName=DM.Prices&dtoFilter=inactiveProductsFilter"/>
Deprecated from 1.1.15:
<pfx:dmTruncate id="truncatePricesDM" targetName="DM.Prices"/>
<pfx:dmTruncate id="truncatePricesDF" targetName="DMF.Prices" typedId="692.DMDL"/>
<pfx:dmTruncate id="truncatePricesDF" targetName="DMF.Prices" incrementalDate="2019-01-28T11:30:00"/>
<pfx:dmTruncate id="truncatePricesDS" targetName="DMDS.Prices"/>
<pfx:dmTruncate id="truncatePricesDS" targetName="DMDS.Prices" dtoFilter="inactiveProductsFilter"/>
IntegrationManager version 5.8.0