This content has been marked as final. Show 6 replies
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.