Row Generation :-
The Row_Generation transformation is represented by the above symbol.
Def:- Row generation Produces a data set with a single column.
The column values start with the number that you set in the Row number starts at option.
The value then increments by one to a specified number of rows.
The column values start with the number that you set in the Row number starts at option.
The value then increments by one to a specified number of rows.
As per the definition it creates the data sets based on the number you provide in the Rou count.
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.
so that the newly created column will be populated with the values given by Row_Generation.
Lab:-
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, Now 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 1 and the row count to 1 to have one set.
Based on the number you provide in the Row count, those many sets of
data will be generated in the output table.
Go back to by clicking on
and create a template table.
and create a template table.
Create a template table and 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.
