6 Replies Latest reply: Apr 20, 2017 10:43 AM by klaus skalts RSS

    Synthetic Keys

    Mark Ritter

      Let's say that you write a script with multiple sections.  You load 1 table and then a 2nd.  If you only run these 2 sections you have generated a synthetic key with 4 fields. 


      If you let the rest of the script run by the time you get to the end you have no synthetic keys because tables have been dropped along the way.


      My question is, does this matter?  Are synthetic keys only created at the end of the script?  Or do you want to make sure that you don't have any from start to finish?


      I hope that made sense.