How do I generate new primary keys?

CloverDX Platform
1

Hi,

I’m currently in the process of learning CloverELT Designer and I’ve stumbled onto the following problem:

I’m merging 2 databases and I’d like to:
-generate new primary keys while keeping the foreign keys consistent

How would I go about this?

Thanks you very very much!

2

Hi Jwizzman,

For unique primary keys generating in CloverETL you can use sequences: http://doc.cloveretl.com/documentation/ … ences.html

If output of your merge is loaded into another database, you can generate primary keys during inserting records into it.

I hope this helps.