Hi, I'm Ask INFA!
What would you like to know?
ASK INFAPreview
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

Configuring Sessions for a Siebel Target

Configuring Sessions for a Siebel Target

The following table describes the session properties for a Siebel target:
Session Property
Description
Duplicate Parent Row Handling
Select one of the following values to indicate how the PowerCenter Integration Service handles duplicate parent rows:
  • First Row. The PowerCenter Integration Service writes the first row to the target and rejects subsequent rows with the same primary key.
  • Last Row. The PowerCenter Integration Service writes the last duplicate row to the target. The PowerCenter Integration Service rejects other rows with the same primary key.
  • Error. The PowerCenter Integration Service writes the first row to the target and increments the error count each time it encounters other rows with the same primary key. The session fails when the error count exceeds the error threshold.
Orphan Row Handling
Select one of the following values to indicate how the PowerCenter Integration Service handles orphan rows:
  • Ignore. The PowerCenter Integration Service ignores orphan rows.
  • Error. The PowerCenter Integration Service treats orphan rows as error. The PowerCenter Integration Service increments the error count when it encounters an orphan row. The session fails when the error count exceeds the error threshold.
Cache Directory
Directory used to cache the Siebel target data. The default cache directory is $PMCacheDir.
Cache Size
Maximum buffer size the PowerCenter Integration Service uses to cache data before writing to the Siebel target. The default cache size to store the Siebel target data is 10 MB. The minimum value for cache size is 80 KB. You can set the cache size equal to 20 percent of the available memory of the system.
You can view load statistics in the session log. The load summary in the Workflow Monitor does not display load statistics.

0 COMMENTS

We’d like to hear from you!