Using a Siebel EIM Invoker Transformation in a Mapping
Using a Siebel EIM Invoker Transformation in a Mapping
You can use the Siebel EIM Invoker transformation in a mapping to invoke an EIM task. When the PowerCenter Integration Service invokes the EIM task, Siebel EIM invokes the business function specified in the IFB file.
For example, you can configure the IFB file to delete rows from a Siebel base table.
The following figure shows a Siebel EIM Invoker transformation mapping that invokes an EIM task to delete rows from base tables:
The mapping contains the following components:
Customer_Database. A source flat file that provides a value to the INPUT_STATUS port of the Siebel EIM Invoker transformation. When you run the session, the PowerCenter Integration Service invokes the EIM task if the value of the INPUT_STATUS port of the Siebel EIM Invoker transformation is not set to 0.
SQ_Customer_Database. An Application Source Qualifier that links the input status in the source flat file to the INPUT_STATUS port of the Siebel EIM Invoker transformation.
SIT_DeleteRows. A Siebel EIM Invoker transformation used in the mapping to invoke the EIM task that deletes the rows from the Siebel base table specified in the IFB file.
CustomerDetails_Deleted. After the PowerCenter Integration Service invokes the EIM task, it writes the output status to the CustomerDetails_Deleted flat file target.
If the PowerCenter Integration Service invokes the EIM task successfully, Siebel EIM deletes the rows from the base table. When Siebel EIM attempts to delete a row from the Siebel base table, it updates the corresponding row in the EIM table to indicate the status of the deletion. When it successfully deletes a row, Siebel EIM writes the batch number in the IF_ROW_BATCH_NUM column and the status 'DELETED' in the IF_ROW_STAT column of the EIM table.
ASK INFAPreview
