Diff bw gen_row_num() and row_gen

dataservices job design
1

Can someone explain difference between gen_row_num() and row generation.if posible with an example?

rajnia1 (BOB member since 2011-11-17)

2

Gen_Row_Num() is a function and here you cannot set the initial value and also cannot set the limit as it will generate the keys until you input records.

In row generation transform you can set the initial limit and well as the row count indicating the number of rows in the output data set. You can also initialize it with a Global variable. You are privileged with quite a few options when using row_generation which you can go through in SAP BODS Technical Manuals.

Cheers,
Shazin

Shazin :india: (BOB member since 2011-07-19)

3

To add on, a row generation transform is normally used when you do not have any source / do not expect any records from the source and still want to generate a row/specified number of rows to commit to the target.

gen_row_num fills a field / column with incremental numbers. They require source records to function.

Regards,
Suneer.

suneer333 :us: (BOB member since 2010-07-15)