Notes on Row_generation: Infact it does nothing it produces an integer column with values starting from 0 and incremented one upto the row range you specified.
Row count: You can specify a positive value here that these many rows to generate for a column.
Design Steps: I want to generate 3 rows for each row in the DEPT source
- Place a Row_generation transform from object library, a SCOTT.DEPT table as another source and in the next step connect it to query transform and then target object.
- In the QRY transform i dragged all the columns from both the sources and i haven’t join these sources as i want cartesian result
- Connect QRY O/P to the target object, save the DF definition and execute the job, view the data to see the resultant data