Key Generation

[former_member557515]

Hi Experts,

  What is the difference between Key Generation and Row Generation...

   Thanks & Regards

Ramesh

[akhileshkiran · Accepted solution]

Hi

Key Generation Transform	Row Generation Transform
Generates new keys for source data, starting from a value based on existing keys in the table you specify	Generates a column filled with integer values starting at zero and incrementing by one to the end value you specify.
It generates the increment value based on the generated key column filed. For example if you want to generate a Surrogate Key Column to avoid duplicate it will generate the key based on the increment 1 followed by the preceding value.	It generate value based on Row Number Starts at and Row Count.                     For example if you want to insert a new row in the table by using row generation you can generate a new row in the target table.
It cannot be used as a source. It need input field to return value	It can be used a source filed to generate output column
Performance Tuning: n/a	Performance Tuning: Join Rank, Cache

Regards,

Akhileshkiran.