Determining the Row-Level Status of Siebel EIM Functions
Determining the Row-Level Status of Siebel EIM Functions
You can use the Siebel EIM Read transformation in a mapping to determine the row-level statuses of the Siebel EIM functions. You can configure the session to only extract particular types of rows from EIM tables, such as erroneous rows. For example, you can use the Siebel EIM Read transformation in a mapping to extract data for the rows that are not successfully imported from Siebel EIM tables into Siebel base tables.
Use a Siebel EIM Load transformation to load data from a source to the Siebel EIM table.
Use a Siebel EIM Invoker transformation to invoke an EIM task that imports the data from the Siebel EIM table and write it to the Siebel base table.
Use a Siebel EIM Read transformation to extract rows based on a particular status, such as erroneous rows.
The following figure shows a mapping that extracts rows that were not successfully imported from Siebel EIM tables into Siebel base tables, and then loads the rows into corporate data sources:
The mapping contains the following components that load bulk data into Siebel base tables, and then exports rows that were not successfully loaded into the Siebel base table:
Account. An Oracle source that provides rows to be loaded into the Siebel base table and the input status for the INPUT_STATUS port of the Siebel EIM Load transformation.
SQ_Account. An Application Source Qualifier that links the source rows and input status to the input ports and INPUT_STATUS port of the Siebel EIM Load transformation.
SLT_EIM_ACCNT_DTL. A Siebel EIM Load transformation that loads data from the source into the Siebel EIM tables and writes the batch number and EIM table name in the CONTROL_FIELDS output group for the rows loaded into EIM tables. It provides these values for the CONTROL_FIELDS group of the Siebel EIM Read transformation. The Siebel EIM Load transformation also outputs the status of the load to the Siebel EIM Invoker transformation.
SIT_Import_Export. A Siebel EIM Invoker transformation invokes the EIM task to load the Siebel base table. Siebel EIM runs the EIM task on the Siebel server to import the rows from the EIM tables into the base tables specified in the IFB file. It writes the batch number in the IF_ROW_BATCH_NUM column and updates the statuses in the IF_ROW_STAT column of the EIM table for all the rows marked for import. After it invokes the EIM task, the Siebel EIM Invoker transformation provides the input status for the INPUT_STATUS port of the Siebel EIM Read transformation based on whether the EIM task was invoked successfully.
SRT_EIM_ADDR_ORG. A Siebel EIM Read transformation that extracts rows that were not successfully loaded into the Siebel base tables. The Siebel EIM Read transformation determines rows that were unsuccessfully loaded based on the IF_ROW_STAT column in the EIM table. The PowerCenter Integration Service then writes the output status to the OUTPUT_STATUS port of the Siebel EIM Read transformation and the read summary to the session log.
Account_FF. The PowerCenter Integration Service writes extracted data to this flat file target.
CTI_CFG. The PowerCenter Integration Service writes other extracted data to another flat file target.
ASK BOLOPreview
