Key Analysis on GUIDs
Posted: Tue Mar 18, 2014 3:55 pm
We are profiling some tables that are joined together with GUIDs. When we get to Key and Cross Domain Analysis IA correctly identifies the PKs but does not identify FK candidates.
I must admit that we have never gone this far into profiling so we may be doing something wrong here in order to identify the FKs, however, we discovered that it may have something to do with the LENGTH of the GUID columns (length=64). With some experimentation using shorter length idenitifiers, the FK candidates DO get identified. The magic number seems to be somewhere between 48 characters (this works) and 56 characters (does not work). As well, we have noticed that using the longer lengths results in the Format of the data being changed from a real format like '99a9a.999aa9.a9a9a.999a999.999a9a9a.999aa9.a9a9a.999a999' to simply 'NA'.
Is someone able to help resolve this issue so we can do Cross Domain analysis using GUIDs?
Thanks in advance!
I must admit that we have never gone this far into profiling so we may be doing something wrong here in order to identify the FKs, however, we discovered that it may have something to do with the LENGTH of the GUID columns (length=64). With some experimentation using shorter length idenitifiers, the FK candidates DO get identified. The magic number seems to be somewhere between 48 characters (this works) and 56 characters (does not work). As well, we have noticed that using the longer lengths results in the Format of the data being changed from a real format like '99a9a.999aa9.a9a9a.999a999.999a9a9a.999aa9.a9a9a.999a999' to simply 'NA'.
Is someone able to help resolve this issue so we can do Cross Domain analysis using GUIDs?
Thanks in advance!