topic Re: Generating unique id to a string present across 7 tables in Data Quality

Generating unique id to a string present across 7 tables

anoopbhargavakm — Sat, 16 Nov 2024 00:01:20 GMT

Hi All,

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

Re: Generating unique id to a string present across 7 tables

Anonymous — Wed, 23 Jun 2021 02:49:04 GMT

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