Database Reference
In-Depth Information
The skeleton - a mapping
In the earlier section, you learned about all the prerequisites to create a mapping. Mapping
is a structural flow of data from the source to target through transformations.
To understand the basic steps of creating a mapping, let's start by creating a pass-through
mapping. A pass-through mapping inserts all the source rows into the target without any
modifications.
We will use the
EMPLOYEE
Oracle table as source and the
TGT_EMPLOYEE
table as target
to create a pass-through mapping.
By performing the following steps, you will create a mapping and link columns in the
source
EMPLOYEES
table to a source qualifier transformation:
1. Navigate to
Tools
|
Mapping Designer
and then to
Mappings
|
Create
to create a
new mapping.