In some cases, it is necessary to join two tables based on columns with different data types. For example, a fact table contains a SKU as a character field (CHAR), but the lookup table has a SKU as an integer (INT).
In SQL Server, the CAST() function is used to convert data into a different data type and the ApplySimple() function in Strategy can be used to incorporate the CAST() function.
To convert a CHAR to an INTEGER in Strategy for SQL Server, change the definition of the attribute as follows:
ApplySimple("cast(#0 as INT)", SKU_IN_CHAR)
Note: Ensure that the Update Schema is run after modifying the attribute.
