Data Transformation Engine Design Studio Tutorial

Introduction Tutorial Objectives

Design Studio Tutorial

These applications perform the design-time functions of the Mercator Integration

Broker Suite. The design-time functions of the Integration Broker Suite define how

your data will be transformed. Design-time tasks include:

♦ Defining data definitions.

♦ Defining data transformation rules.

♦ Defining business process models.

♦ Defining other specifications.

The run-time functions are the execution of maps and systems of maps in a

production environment. For example, the Integration Flow Designer manages

collections of maps at design time, while a Command or Event Server manages

the execution of maps at run time. Run-time functions are not discussed in this

tutorial. See the Getting Started book for the Integration Suite product

information.

This tutorial focuses on the design-time functions performed in three of these

applications: the Map Designer, the Type Designer, and the Integration Flow

Designer. Due to the database-dependent nature of the Database Interface

Designer, no tutorial exercises using that designer are included in this tutorial.

Tutorial Objectives

Completing this tutorial will enable you to use the Design Studio applications.

You will be able to:

♦ Create and modify type trees and maps.

♦ Use functions in map rules.

♦ Include cross-referenced data in your maps.

♦ Define breaks in data.

♦ Create functional maps to process specific data transformation.

♦ Create nested functional maps.

♦ Use functions in map rules.

♦ Use functions in component rules.

♦ Associated related data.

♦ Build business rules in your data transformation.

♦ Create trace files.

♦ Export a map.

♦ Build a validation map.