Tibco Data Transformation/Mapper Feature

In this walk through, I would brief about mapping features in TibcoBW.

Below is our source schema consist of multiple repeating records and our requirement is to map it to single party destination node which is also a repeating node.

Here is the destination schema, where party node is repeating and each party node can only have child nodes of info with in party.

In TibcoBW process, we would use file poller and xml parse to render data into BW process and then use DataMap activity to achieve the mapping logic.
In input tab of DataMap activity, Right Click on Party node, choose Statement and then Duplicate. This would create a party node and complete the mapping from source Submitting party to Duplicate Party Node.

Similarly, on the contact node of duplicated party; Right Click on Contact node, choose Statement and then Surround With Choice Option. Map the contacts from Submitting Party Source to Duplicated Party Contacts as shown above.

As there is similarly logic of Contact mappings for all the party node, this can be copied and pasted to the other maps as well. Below, shows the mapping of Party Node from source to Party node in destination using For-Each logic and contact mapping is copied and used over here.

Lets run the project and test the output.

The video demonstration is available on the YouTube, here is the embedded video.