This tutorial shows you how to use the Rowgen 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 Row Generation object from the transform/platform area.
  • connect Row Generation Object & the Source table to the Query Object.
  • Add a Template Table from the Menu in the Right, Enter its name & the select the data store where it needs to be created.
  • connect Query Object to the template table.
  • Open the Row Generation object & provide the values for Row Generation starts at & Row count parameters.
  • Open the query object, drag & drop the columns required to the output area & Drag and drop the DI_Row_ID column from the Row generation Source Schema.
  • Validate & Run the Job.
  • View the output table data to confirm