Transliterations in the Model

The following example creates a single data source, based on a query subject of two tables. The tables are identical except for the use of Asian characters in one table.

Column with names that end with the suffix _MB store Asian-related data using Asian characters, such as Chinese ideograms. This removes some duplication and makes it easier to define relationships to other query subjects in the model.

Select
RS.RTL_RETAILER_SITE_CODE,
RS.RTL_RETAILER_CODE,
RS.RTL_ADDRESS1,
RS.RTL_ADDRESS2,
RS.RTL_CITY,
RS.RTL_REGION,
RS.RTL_POSTAL_ZONE,
RS.RTL_COUNTRY_CODE,
RS.RTL_ACTIVITY_STATUS_CODE,
RS_MB.RTL_ADDRESS1 as Address1_MB,
RS_MB.RTL_ADDRESS2 as Address2_MB,
RS_MB.RTL_CITY as City_MB,
RS_MB.RTL_REGION as Region_MB
from
[goretailers].RETAILER_SITE as RS,
[goretailers].RETAILER_SITE_MB
as RS_MB
where
RETAILER_SITE.RETAILER_SITE_CODE = RETAILER_SITE_MB.RETAILER_SITE_CODE