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

Working with Siebel Sources

Working with Siebel Sources

A Siebel business component can contain single-value and multi-value fields. A single-value field can store one value at a time and a multi-value field can store more than one value at a time. A multi-value field has an associated multi-value link attribute that corresponds to the destination business component for this field.
A multi-group source contains groups for single-value and multi-value fields. All the single-value fields are part of the first group. The multi-value fields with the same multi-value link are part of the same group. The group containing the single-value fields is the parent group for all the groups in that source. The other groups are child groups of the parent group.
The following table shows an example of the Account business component with fields and groups:
Fields
Field Name
Multi-value Link
Group
Destination Business Component
Single-value
Account
-
Account
-
Single-value
Account Number
-
Account
-
Multi-value
Street Address
Business Address
Business_Address
CUT Address
Multi-value
City
Business Address
Business_Address
CUT Address
Multi-value
Position
Position
Position
Position
Multi-value
Position ID
Position
Position
Position
An account name can be associated with multiple addresses. Therefore, each Account row can have multiple rows with Street Address and City columns. Multiple rows are stored as data of the CUT Address business component. An account name can be associated with multiple positions. Therefore, each Account row can have multiple rows with Position and Position ID columns. Multiple rows are stored as data of the Position business component.
The following figure shows the Account business component containing Position with a multi-value link attribute Position:
 In the Import from Siebel dialog box, you csn enter the filter condition and click Load Objects. Select the required business object and then select the business component.
The Account source definition contains a group for Name and Account Number, a group for Position and Position ID, and the other group for City and Street Address.

0 COMMENTS

We’d like to hear from you!