Row Generation in BODS

The Row_Generation transformation is represented by the above symbol.

Definition:-  Row generation produces a data set with a single column. The column values start with the number that you set in the option “Row number starts”. The value then increments by 1 to a specified number of rows.

As per the definition it creates the data sets based on the number you provide in the Row count.

Definition as per SAP Standard Document:

Generates a column filled with integer values starting
at zero and incrementing by one to the end
value you specify.

Example:- Add a column to the schema out in query transformation and link that to the Row_Generation, so that the newly created column will be populated with the values given by Row_Generation.

Steps:-

Create a job.

and name the job as Job_RG.

Create a DataFlow.

Select the data flow on the right side pane and click back on the designer space and name the dataflow as DF_RG.

Drag a table from your data store in to your designer.

Drag Row_Generation transformation from transform under Platform under local object library-

Add a query transform to the designer window.

Now link both the table and the Row_Generation to the Query transform. Click on the query and open it. Drag all the fields from the table under schema in to the schema out. Select the top field on the schema out and right click and click on “ New output column”, Click on “ Insert above” . Name the new output column as RGNO.

Now map the row generation from schema in to the newly added column “RGNO” in schema out.

Now click come back by clicking on   and click on the Row Generation Transformation in the designer window to open it.

Set the Row Number starts at option to 1 and the row count to 1 to have one row. Based on the number you provide in the Row count, those many rows of data will be generated in the output table.

Go back to by clicking on  and create a template table.

Join the query transform to the template table.

Now save all  and validate all  to see the errors if any.

Once saved, select the job, right click and execute.

Once the job executes successfully, go to the template table and see the results by clicking on the magnifying glass.