How do I generate new primary keys?

jwizzman

• June 07, 2013 00:00

• Answered

Follow

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!

• 

  admin

  • June 07, 2013 14:58

  0

  Comment actions Permalink

  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.