Generated Key Column and Key Generation Transform

[rajan_burad]

Hello,

I implemented a scenario in which I used source -> query -> table_comparison -> target. In target I added Cust_gen column and after job execution I found that it contains null values which is correct as I have not added any key generation transform to get the values.

Now after this I added Key generation transform to check how it actually works and added a row in source and after execution of job i found that cust_gen column has a set of values for every record but I have read that it looks for maximum existing value and then assigns value to newly inserted records. So as per my understanding the maximum value in source is 501 and the value of cust_gen should start from 501.

Can someone please help me that how does this Key generation transform works and also why every record has got values of cust_gen.

Regards,

Rajan

[Former Member]

Hi Rajan,

The surrogate key column is created in BODS (in query transform) and this column should be made primary key and use this in Key generation transform. It will create keys serially. it will not create random keys.

Please let me know if you need more info

[rajan_burad]

Hello Ravi,

I added this surrogate column (Cust_gen) in query transform and same applied in TC and Key_gen and ran the job, but still found that its giving null values.

Also I mapped the input cust_id column with this surrogate key.

I have attached the screenshots of my job.

Please let me know where did I went wrong.

Thanks much for your help!! 🙂error-03.pngerror-04.pngerror-05.png