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.