Simple mapping and tMap time savers
This recipe will illustrate the most basic mapping options within the tMap
component and some of the column level tricks that can be used to speed up mapping by removing large amounts of repetitive actions.
Getting ready
Open the job jo_cook_ch04_0010_basicMapping.
How to do it...
- Drag a
tMap
component from the right-hand panel. - Connect the
tFileInputDelimited
component totMap
. - Connect the output, name it as
outputCustomer
and accept the schema of the target component. - Open
tMap
and you will notice that the inputs and outputs are named the same as the flows.Rename the flows
- Close
tMap
and left-click the input flow so that row1 is highlighted. Take a short pause; click again on therow1
text and the text will be editable. Rename the flow tocustomer
. - Open
tMap
and you will see that the names of thetMap
input table have now changed to match the row name of the input flow.Manually dragging columns
- Click the left mouse button on
dateOfBirth
and drag todateOfBirth...