You use the Select transform to retrieve database information and to perform transformations between the input elements and the output elements of the Message Assembly.
Add the database tables to the message map FindAddress.map. For more information, see Adding database tables your message map.
You can use the Select transform in a message map to enrich a message with database information.
The Select transform retrieves records from a database based on the SQL where clause that you define when you add tables to a message map.
A Select transform has a nested map. This nested map is where you transform the input and output elements of the Message Assembly.
You can set the cardinality of the Input array indexes in the Select transform properties view to work with a particular row or set of rows, or you can leave this field blank to choose all rows.
This section explains how to configure the Select transform when the data available in three database tables is retrieved in one result set.
Complete the following steps to enrich a message with the address of a client from the CLIENTS database:
You have successfully configured the nested map of the Select transform.
The following figure shows the nested map:
Handle failure of the Select transform in a message map. For more information, see Handling database failures in a Select transform.