SQL Server Performance

dimension & fact table with diff datatype key?

Discussion in 'Analysis Services/Data Warehousing' started by tboonleong, Mar 8, 2007.

  1. tboonleong Member

    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 .

  2. ranjitjain New Member

    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.

Share This Page