When we creating a numeric field in a MDW table, TX suggets use a numeric(38,6) for the data type.

When the field it’s translated to the semantic model it’s detected in TX:

But in the model:

And one of the best practice rules says “Do not use floating point data types”.
How can I follow this rule?
Best answer by rory.smith
View original