Need information on Generating unique row number

[former_member264991]

Hello All,

My requirement is to generate unique row numbers for a column ROW_ID.

I used GEN_ROW_NUM function to generate row numbers, it generated a sequence say from 1-1000. However, when I tried to load a new file, It again generates the row number starting from 1.

This column ROW_ID value should start with the previous maximum count of column ROW_ID and then raise the counter by 1.

Similarly should continue while loading other files.

Can any one please advise me on this requirement?

Regards,

Rajiv

[former_member27665]

If you are loading file to a permanent table then like you mentioned, use this table in key generation transform. Refer this link for more details.