Powercenter Mapping to establish Master Detail ... Skip navigation

Powercenter Mapping to establish Master Detail Relationship with simple Mapping Variable

score 0
You have not voted. Active

Use Case:

  • Dataset indicating header and detail records are provided
  • Header Rows and Detail Rows are ordered so that every header row is followed by its corresponding set of detail rows
  • Besides the order of the rows and a row-type of 'H'=Header and 'D'=Detail, there is no other data element in the source which ties the header rows to all of its corresponding detail rows.

 

Requirement:

  • Mapping to generate a target that includes a key on every header row and the same key to be included on every detail row that is associated with the right header row

 

SOURCE DATA SET PROVIDED:

 

ROWTYPE

TEST_ID

TEST_DESCRIPTION

H

111

TEST-111

D

222

TEST-222

D

333

TEST-333

D

444

TEST-444

D

555

TEST-555

H

666

TEST-666

D

777

TEST-777

D

888

TEST-888

D

999

TEST-999

D

101010

TEST-101010

D

111111

TEST-111111


TARGET DATA SET TO BE GENERATED:

 

ROWTYPE

TEST_ID

TEST_DESCRIPTION

LINK

H

111

TEST-111

9

D

222

TEST-222

9

D

333

TEST-333

9

D

444

TEST-444

9

D

555

TEST-555

9

H

666

TEST-666

10

D

777

TEST-777

10

D

888

TEST-888

10

D

999

TEST-999

10

D

101010

TEST-101010

10

D

111111

TEST-111111

10

Comments

Vote history