Chapter 12 Creating Mappings

Mapping examples

Simple mapping

A simple mapping can be designed as follows. The CITY table and its columns in the Source pane are mapped to the CITY table and its columns in the Target pane. Note that columns mapped automatically:

Multiple sources mapping

A mapping with multiple sources can be designed as follows. The CITY table in the Target pane has two sources (CITY and SALE tables):

Different mappings for the same target

A same target object can have different mappings. The SALE table in the Target pane is mapped to the SALE table (Mapping_1) and to the STORE table (Mapping_2) in the Source pane:

Copyright (C) 2008. Sybase Inc. All rights reserved.