topic VIN data performance in QlikView https://community.qlik.com/t5/QlikView/VIN-data-performance/m-p/1338643#M412601 <HTML><HEAD></HEAD><BODY><P>Has anyone worked with the 17-character VIN in their dimensional model.</P><P></P><P>We broke it up into 3 pieces: </P><P></P><TABLE border="1" class="jiveBorder" height="102" style="border: 1px solid rgb(0, 0, 0); width: 180px; height: 103px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Positions<BR /></STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><P><STRONG>Distinct values<BR /></STRONG></P></TH></TR><TR><TD style="padding: 2px; text-align: center;">1-6</TD><TD style="padding: 2px; text-align: right;">21,588</TD></TR><TR><TD style="text-align: center;">7-11</TD><TD style="text-align: right;">207,482</TD></TR><TR><TD style="text-align: center;">12-17</TD><TD style="text-align: right;">1,470,040</TD></TR></TBODY></TABLE><P></P><P>We currently have a start but would it better to snowflake the dimension?</P><P></P><TABLE border="1" class="jiveBorder" height="52" style="border: 1px solid rgb(0, 0, 0); width: 88px; height: 53px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">VIN</TH></TR><TR><TD style="padding: 2px;">%VIN</TD></TR><TR><TD>%VIN01_06</TD></TR><TR><TD>%VIN07_11</TD></TR><TR><TD>%VIN12_17</TD></TR></TBODY></TABLE><P></P><TABLE border="1" class="jiveBorder" height="50" style="border: 1px solid rgb(0, 0, 0); width: 87px; height: 42px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>VIN01_06</STRONG></TH></TR><TR><TD style="padding: 2px;">%VIN01_06</TD></TR><TR><TD>VIN01_06</TD></TR></TBODY></TABLE><P></P><P>etc..</P><P></P><P>When is snow-flaking a good design decision?</P></BODY></HTML> Thu, 25 May 2017 14:17:18 GMT markp201 2017-05-25T14:17:18Z VIN data performance https://community.qlik.com/t5/QlikView/VIN-data-performance/m-p/1338643#M412601 <HTML><HEAD></HEAD><BODY><P>Has anyone worked with the 17-character VIN in their dimensional model.</P><P></P><P>We broke it up into 3 pieces: </P><P></P><TABLE border="1" class="jiveBorder" height="102" style="border: 1px solid rgb(0, 0, 0); width: 180px; height: 103px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Positions<BR /></STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><P><STRONG>Distinct values<BR /></STRONG></P></TH></TR><TR><TD style="padding: 2px; text-align: center;">1-6</TD><TD style="padding: 2px; text-align: right;">21,588</TD></TR><TR><TD style="text-align: center;">7-11</TD><TD style="text-align: right;">207,482</TD></TR><TR><TD style="text-align: center;">12-17</TD><TD style="text-align: right;">1,470,040</TD></TR></TBODY></TABLE><P></P><P>We currently have a start but would it better to snowflake the dimension?</P><P></P><TABLE border="1" class="jiveBorder" height="52" style="border: 1px solid rgb(0, 0, 0); width: 88px; height: 53px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">VIN</TH></TR><TR><TD style="padding: 2px;">%VIN</TD></TR><TR><TD>%VIN01_06</TD></TR><TR><TD>%VIN07_11</TD></TR><TR><TD>%VIN12_17</TD></TR></TBODY></TABLE><P></P><TABLE border="1" class="jiveBorder" height="50" style="border: 1px solid rgb(0, 0, 0); width: 87px; height: 42px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>VIN01_06</STRONG></TH></TR><TR><TD style="padding: 2px;">%VIN01_06</TD></TR><TR><TD>VIN01_06</TD></TR></TBODY></TABLE><P></P><P>etc..</P><P></P><P>When is snow-flaking a good design decision?</P></BODY></HTML> Thu, 25 May 2017 14:17:18 GMT https://community.qlik.com/t5/QlikView/VIN-data-performance/m-p/1338643#M412601 markp201 2017-05-25T14:17:18Z