Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
markp201
Creator III
Creator III

VIN data performance

Has anyone worked with the 17-character VIN in their dimensional model.

We broke it up into 3 pieces:

Positions

Distinct values

1-621,588
7-11207,482
12-171,470,040

We currently have a start but would it better to snowflake the dimension?

VIN
%VIN
%VIN01_06
%VIN07_11
%VIN12_17

VIN01_06
%VIN01_06
VIN01_06

etc..

When is snow-flaking a good design decision?

0 Replies