A single pass through mapping will have source definition. Source qualifier, and an Expression Transformation, and target table. While customizing the mapping we can add other transformations also.
Now let’s see how to create a Pass through Mapping
- Click Mapping Wizards and in that select for Simple Pass Through.
- Give mapping name m_Mapping.
- Select source definition name
- Enter the mapping target table T_TargetName
- Select all source rows
- Insert all rows into Target