dimension & fact table with diff datatype key? | SQL Server Performance Forums

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.
]]>