Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Support and Community,
What makes for a better unique key between fact and dimension tables as far as speed and compression go?
The UID or the ACCOUNT Number shown below in my chart of accounts?
The UID is a longer alphanumeric field and the account number is a fair bit smaller.. Both are text fields in the model.
Hi. I don't think you will found a significant difference. The short one may go faster. The best performance is with int values, but again I don't think you will notice so much difference in this case.
Regards,
Happy to help!
@ibarrau thanks for your reply. Yes my understanding is text characters are slower than number/integer values. The account number however cant be resovled as a number due to the hyphen so it's formatted as text column like the uid.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |