Creating multiple nodes from one database record in MapForce

Date:14th May 2009
Product/Release:LANSA Composer
Abstract:Creating multiple nodes from one database record in MapForce
Submitted By:LANSA Technical Support

Description:

It is possible to map multiple records from one record of a source table (Database Table) using Mapforce. For example, if a customer needs to specify an amount and currency code. In the database file this is all in one record, but the result is required to be in different rows.

Solution:

This functionality can be easily achieved by using the "Duplicate Input" command.

On the target database connection, right-click the node to which you want to map the input multiple times, and click "Duplicate Input" from the pop-up menu. Repeat this the required number of times. Then you can map your input to each of the duplicated target input icons as required.

Based on the above scenario, here is a sample an instance where one record from a table is mapped to multiple records in another table.

A sample an instance where one record from a table is mapped to multiple records in another table