Data Transformation Engine Intelligent Business Integration Reference Guide

Chapter 1 - Introduction Design Environment – Design Studio
Intelligent Business Integration Reference Guide
13
Map Designer
The Map Designer is used to create maps, which consist of rules for data content,
transformation, and intelligent routing. This process is facilitated by convenient
“from” and “to” windows, drag-and-drop techniques, and spreadsheet-like rules.
Mapping rules are added using logical statements. The Map Designer provides a
rich set of over 100 pre-defined functions for operations such as conditional
testing, table lookups, mathematical functions, character string parsing, and data
extraction. Rules and functions can be combined and nested arbitrarily.
The capability for mapping from multiple inputs to multiple outputs gives Mercator
products unique transformation power. Each input to and output from a map is
associated with a specific data object definition and a resource adapter. Data
object definitions are reusable; the same definition can apply to one or more
inputs, to both input and output for the same map, or to different maps. When a
data object is used as input, data is validated to ensure the data conforms to the
data object definition. When used as output, the data object is constructed
automatically, in its entirety.