Forum Discussion

martinrowe's avatar
martinrowe
Advocate I
6 years ago

Vertipaq Column encoding - HASH v VALUE

Is there anyway to understand why vertipaq chooses to encode a column in HASH v VALUE? I have 2 tables where 2 column values are sequential primary keys in MySQL database, one is also a foreign key i...
Need Help
mbujtor's avatar
mbujtor
Frequent Visitor
5 years ago

Hi Martin,

 

I have the same issue:

- the primary key in my fact table (FactKey) got value encoding

- the primary key in my dimension table (DimKey) - also a foreign key in the fact table- got hash encoding

of course both colums are Int64 type.

 

Did you find any solution/explanation for this?

 

Thank you,

Máté