PowerExchange for Siebel User Guide for PowerCenter

10.2
- 10.5.5
- 10.5.4

Back Next

Generating Key Values

When you import a multi-group Siebel source definition, the Designer creates a key relationship between each child group in the source definition and its parent group.

When you create mappings with the primary key-foreign key relationship, the Designer might not create the relationship for the tables. You need to manually set the primary key relationship in the foreign key table.

The following table lists the primary and foreign keys created for the groups in the Account source definition:

Group	Primary Key	Foreign Key
Account	GPK__Account	-
Business_Address	GPK__Business_Address	GFK__Account__Business_Address
Position	GPK__Position	GFK__Account__Position

For a multi-group source, the PowerCenter Integration Service uses row ID as the group primary key of each group. The values for the group foreign keys are taken from the list of values for the group primary keys in the parent group.

The following table shows sample rows contained in the Account group:

GPK__Account	Name	Account_Number
1	James Brown	101
2	John Martin	102

The following table shows sample rows contained in the Business_Address child group:

GPK__Business_Address	GFK__Account__Business_Address	City	Street Address
A	1	Los Angeles	63 Ranch Ave
B	1	Frankfurt	3090 Stevens Creek Blvd
C	2	Dallas	181 Curtner Ave
D	2	San Diego	760 Camino Real

The following table shows sample rows contained in the Position child group:

GPK__Position	GFK__Account__Position	Position	Position ID
E	1	Account Manager	A1
F	1	Business Analyst	B1
G	2	Consultant	C1
H	2	Financial Adviser	C2

In this example, each source represents a group in the source definition. To maintain key relationships when you connect mapping objects, connect source columns in the groups to the corresponding group in the flat file target definitions.

The following table lists column relationships between groups in the Account source definition and flat file target definitions:

Source Group Name	Source Column Name	Target Name	Target Column Name
Account	GPK__Account	Account_rdr1	GPK
Account	Name	Account_rdr1	Name
Account	Account_Number	Account_rdr1	Account_Number
Position	GPK__Position	Position_Account_rdr	GPK
Position	GFK__Account__Position	Position_Account_rdr	GFK
Position	Position	Position_Account_rdr	Position
Position	Position_ID	Position_Account_rdr	Position_ID
Business_Address	GPK__Business_Address	Business_Add_Account_rdr	GPK
Business_Address	GFK__Account__Business_Address	Business_Add_Account_rdr	GFK
Business_Address	City	Business_Add_Account_rdr	City
Business_Address	Street_Address	Business_Add_Account_rdr	Street_Address

The PowerCenter Integration Service extracts the following rows from the Account source definition:

[Account (1, “James Brown”, “101”, Address (A, 1, Los Angeles, 63 Ranch Ave), Address (B, 1, Frankfurt, 3090 Stevens Creek Blvd), Position (E, 1, Account Manager, A1), Position (F, 1, Business Analyst, B1)]
[Account (2, “John Martin”, “102”, Address (C, 2, Dallas, 181 Curtner Ave), Address (D, 2, San Diego, 760 Camino Real), Position (G, 2, Consultant, C1), Position (H, 2, Finance Adviser, C2)]

The following table lists the rows that the PowerCenter Integration Service inserts into flat file targets:

Flat File Target Name	Inserted Rows
Account_rdr1	[1, James Brown, 101] [2, John Martin, 102]
Position_Account_rdr	[E, 1, Account Manager, A1] [F, 1, Business Analyst, B1] [G, 2, Consultant, C1] [H, 2, Finance Adviser, C2]
Business_Add_account_rdr	[A, 1, Los Angeles, 63 Ranch Ave] [B, 1, Frankfurt, 3090 Stevens Creek Blvd] [C, 2, Dallas, 181 Curtner Ave] [D, 2, San Diego, 760 Camino Real]

Rename Saved Search

Table of Contents

PowerExchange for Siebel User Guide for PowerCenter

PowerExchange for Siebel User Guide for PowerCenter

Generating Key Values

Generating Key Values