In the Mapping Designer, click Mappings > Wizards > Getting Started.
Enter a mapping name and select Simple Pass Through, and click Next.
The naming convention for mapping names is m_
MappingName
.
Select a source definition to use in the mapping.
All available source definitions appear in the Select Source Table list. This list can include shortcuts, flat file, relational, and Application sources.
Enter a name for the mapping target table and click Finish.
The new mapping appears in the workspace. The naming convention for target definitions is T_
TARGET_NAME
.
Make necessary edits to the mapping.
Create the target table in the target database before running a workflow.