Generating unique id to a string present across 7 tables

[anoopbhargavakm]

Hi Al​l,

I have a column present in 7 tables . I need to generate a unique id to the values across the tables. Please let me know the best method to generate a unique id without any collisions

[Anonymous]

Hello,

You could use the talend routine Numeric.sequence and editing the result accordingly to any rule or format you need to match.

For oracle DB, here is a documentation about: Using an Oracle sequence while inserting data

Let us know if it helps.

Best regards

Sabrina