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

Attributes

Description

Required by pfx:dmTruncate

Required by pfx-api:truncate

id

ID of the component used for the route name

yes

not available

targetName

Name of Datamart, Data Source or Data Feed

yes

yes

typedId

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

incrementalDate

Value with an incremental date

no

no

dtoFilter
(available from 1.1.15)

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&amp;typedId=692.DMDL"/> <to uri="pfx-api:truncate?targetName=DMDS.Prices&amp;typedId=692.DMDL&amp;incrementalDate=2019-01-28T11:30:00"/> <to uri="pfx-api:truncate?targetName=DM.Prices&amp;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