Difference between row generation and key generation transformations

[Former Member]

Hi,

can anyone please explain the actual difference row and key generation transforms and in what type scenarios we use the row geneartion transformation

[former_member211387 · Accepted solution]

Row Generation provides you the option to introduce one or any number of records into the dataflow for a given requirement. So for instance you dont have a source but there is a constant value that you would need introducing into the dataflow Row_generation will be of use. it is somewhat similar to writing sql statement like "select from dual".

In case of key generation, the transform will generate a sequence of numbers for the given input schema dataset using the key column specified in the transform. it usually starts with the max of the chosen column and continues with the numbering. The field you select for the key column must exist in the input schema of the key_generation transform. The DS Technical manuals will have details on options to go with this transform.

So using row_generation you can generate rows without a source table/file. With key_generation transform you can assign a unqie ID based on a generated key column for the given input dataset. it can even be from the row_generation transform.

kind regards

Raghu

[Former Member · Accepted solution]

Hi raghunathan thanks for your reply,

i have one more doubt that if a column of sequence numbers generated using the row generation transform can we use it as a primary key column by using the query transform?

[Former Member · Accepted solution]

yes, thats correct

[former_member211387 · Accepted solution]

Yes sure. This is fine.