SAP BO Data Services Tutorial: Map operation

This tutorial shows you how to use the Map operation in SAP BO Data Services.

Steps:

• Open Data services
• Create a new job
• Create a new dataflow – drag & drop from the menu on the right
• Add the data source table, using drag & drop from the datastore area.
• Add a query item using drag & drop from the menu on the right.
• Add a Map Transform object from the transform/platform area.
• Add the Target table, using drag & drop from the datastore area.
• connect the Data Source table to the Query Object, Query Object to the Map Operation & Map Operation to the target table.
• Open the query object, drag & drop the columns required to the output area.
• Open the Map Operation Object & change the Normal input row type to Update & the Insert row type to discard as we just want to update the existing data.
• Validate & Run the Job.
• View the output table data to confirm