Mapping process

In general, you use a standard sequence of operations to create and execute a mapping.

1. Select the Create New Mapping function in Integration Composer and specify a source, a target, and a name for the mapping.
2. Establish connections to the source and target databases. If one of the data sources is not open Integration Composer requests this information. This step is not always required; if the source and the target databases are already open, you do not have to establish the connection.
3. Import an Integration Composer adapter mapping or use Integration Composer to define expressions for transforming data from the source to the target.
4. Save and close the mapping.
5. Sign out of Integration Composer.
6. Execute the mapping using a command line instruction.