On Mon, 2005-05-09 at 09:01 -0500, Jay Sprenkle wrote: > > Has good hints on where to get your globally unique identifiers. > > > > Or translate the original keys to globally unique identifiers within a > > transaction before loading into your master database. > > Works fine if you don't have any overlap between products on the two > systems. You might get the same product twice, each with a different > global unique number.
If the products were created separately, then they would indeed be different products. If they were created from distribution, then their product identifiers would share the same globally unique identifier. If you don't like this, then you want the product name [or UPC, or whatnot] to be the product "id" and you certainly do NOT want globally unique identifiers- but instead globally distinct identifiers.
