In this step, you create a Source transformation to specify the source object.
When you design a mapping, the first transformation you configure is the Source transformation. You select the source object in the Source transformation. The source object represents the source of the data that you want to use in the mapping.
Add the source object at the beginning of mapping design because the source properties can affect the downstream data. For example, you might filter data at the source, which affects the data that enters downstream transformations.
Use the CUSTOMERS table in the Oracle Mock Connector as the source object.
1On the mapping canvas, click the Source transformation to select it.
2In the Properties panel, click General and enter src_SampleCustomers for the Source transformation name.
3Enter the connection to use based on the source object. In this case, the source object is an Oracle table, so the connection needs to be an Oracle connection.
Click Source and configure the following properties:
Source detail
Description
Connection
Connection to the sample Oracle data.
Select the Oracle mock connection that you set up before you started the tutorial, Sample Oracle Connection (MockConnector).
Source Type
Source type, which can be an object or a parameter.
Select Single Object.
Object
Source object for the mapping.
Click Select and choose the CUSTOMERS table.
If you want to view the data in the source file, click Preview Data.
The following image shows the source details in the Properties panel:
4If you want to view the source fields and field metadata, click the Fields tab.
5To save the mapping and continue, click Save.
The mapping will be marked "Invalid" at this point because you haven't configured the target yet.