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!
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!
-
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.
Please sign in to leave a comment.
Comments 1