Achieving S-O-I-P-I-P from S-O-I-P-P

The Challenge: The current map is sending S-O-I-P-P to the mailbox which is reflective of the records in the UFD/file. How will I use the same records to achieve S-O-I-P-I-P? (without changing the records in the file or asking my ERP to shuffle around its records. Direct-by-key is the access method of my UFD.

The Analysis: At the state the current mapper is in, the S-O-I-P-P is driven by 5 records: a Shipment, an Order, an Item (D04) and 2 Packs (D05). The Shipment is brought to the mapper by the ID Field: Partner Internal ID. The key source from the Shipment record, brings in the Order, which in turn brings in the Item which is linked to the the 2 Pack records.

If we 1) swap the record association of Item to D05 (which use to be the Pack's) and the Pack to D04 (which use to be the Item's). And adjusting the 2) key sources and 3) review mapping accordingly (although mapping changes will be close to *none), the S-O-I-P-I-P is achieved. When the Order record brings in the first D05 record (Item), the HL-I is created. Because of the new key source configuration, brings in the only D04 record (Pack) and sends the first HL-P record to the mailbox. Then the next D05 record is read, then another HL-I is created, then brings in the same D04 record (because of the key source configuration) - sending another HL-P to the mailbox.

Do you have a new CHALLENGE? Let us know HERE.