I have a dimension table that contains a GUID generated presumably by SQL Server at the source (a different machine from the one the dim table lives on). Now I need to add a 2nd source which lives on a different machine (but also SQL Server) and does not have GUIDs generated for it. My question is if I create new GUIDs for the 2nd source on the fly while loading data from both sources into my target dim table, willl there be any chance of a collision with GUIDs from the 1st source? I know GUIDs maintain uniqueness across databases if they're on the same server but I don't know about totally separate servers.
Thanks in advance,