SQL Server Performance Forum – Threads Archive
dimension & fact table with diff datatype key?At cube , if the fact table column A link to dimension table column B, but both diff data type then sure can not link. The column A is varchar and column B is numeric.
Any other way to link if we dont want to change the fact table column A’s data type?
Thanks in advance .
You should avoid coercion of data types as it might increase processing time.
For now, you can even look for creating a view with right datatype as you need.
Also numeric should be preferred over varchar for joining.