Creation of Mapping

A mapping is created using mapping designer tool in the designer client component.

PROCEDURE:

• From tools menu

• Click on mapping designer                                          
• Go to mapping menu

• Select create

• Enter mapping name (m-simplepass)

• Click ok

• From repository navigator window expand the source subfolder, drag the source definition (EMP), and drop on mapping designer work space.

• From target subfolder drag the target definition (t-employee), drop on mapping designer work space.

• without source qualifier the integration service cannot perform extraction from the source definition the source qualifier the sql queries to extract the data.

• From source qualifier connect the columns to the target definition.

• From repository menu click on ‘save’.

• A source qualifier is automatically created when we drag and drop the source definition in the mapping designer’s work space.