Hi, I'm Bolo!
What would you like to know?
ASK BOLOPreview
Please to access Bolo.

Table of Contents

Search

  1. Preface
  2. Understanding PowerExchange for Siebel
  3. PowerExchange for Siebel Configuration
  4. Siebel Sources
  5. Application Source Qualifier for Siebel Sources
  6. Siebel Targets
  7. Siebel Business Service Transformation
  8. Siebel EIM Read Transformation
  9. Siebel EIM Load Transformation
  10. Siebel EIM Invoker Transformation
  11. Siebel Sessions
  12. Datatype Reference
  13. Error Messages
  14. Glossary

PowerExchange for Siebel User Guide for PowerCenter

PowerExchange for Siebel User Guide for PowerCenter

Importing Data from Siebel EIM Tables into Siebel Base Tables

Importing Data from Siebel EIM Tables into Siebel Base Tables

You can load data from a corporate source into Siebel EIM tables and then invoke an EIM task to import data from Siebel EIM tables into Siebel base tables.
For example, you need to import new employees data into Siebel base tables. After you configure the mapping to load the employee rows into an EIM table, you configure the Siebel EIM Invoker transformation to import the rows from EIM tables into the Siebel base table.
To configure the Siebel EIM Invoker transformation, configure the following values for parameters in the IFB file as in the following table:
Parameter
Value
TYPE
Import
BATCH
1
The following figure shows a mapping that loads data from a corporate source into Siebel base tables:
The mapping contains the following components:
  • New_Employees. A source flat file that contains data to be loaded into EIM tables. The source ports provide values to the input group of the SLT_EIM_Emplyee transformation.
  • SQ_New_Employees. An Application Source Qualifier that links the source fields to the ports in the input group of the SLT_EIM_Emplyee transformation.
  • SLT_EIM_Employee. A Siebel EIM Load transformation that loads data from the source into the Siebel EIM tables. The PowerCenter Integration Service loads data into EIM tables for all ports of the input group linked in the SLT_EIM_Employee transformation. It also writes the batch number and EIM table name in the CONTROL_FIELDS output group for the rows loaded into EIM tables. The PowerCenter Integration Service writes the output status of the load operation to the STATUS output group and the rows that were not successfully loaded into EIM tables to the ERROR output group. It also writes the load summary to the session log.
  • Employee_Details. A target flat file to which the PowerCenter Integration Service writes the data from the CONTROL_FIELDS group of the SLT_EIM_Employee transformation.
  • SIT_Employee_Details. A Siebel EIM Invoker transformation that invokes the EIM task to write data from the Siebel EIM table to Siebel base tables. The Siebel EIM Invoker transformation invokes the specified EIM task if the input status equals '1.' After the PowerCenter Integration Service invokes the EIM task, it writes the output status to the OUTPUT_STATUS port of the SIT_Employee_Details transformation.
  • Error_Employee_Details. A target flat file to which the PowerCenter Integration Service writes the erroneous rows from the ERROR output group of the SLT_EIM_Employee transformation.

0 COMMENTS

We’d like to hear from you!