Preferred Language Code (S_CONTACT.PREF_LANG_ID)
In UCM we load data both through batch and through real-time web services. In both cases, the value provided is the 3-digit language code (e.g. "ENU", "FRA", "ITA", etc). This is per the OOTB configuration mention in the previous post. For batch, the S_UCM_CONTACT.PREF_LANG_ID is populated via the UCMContactSourceDataAndHistory->Contact->Preferred Language Code field. This then populates the S_CONTACT.PREF_LANG_ID via the CIFContactInsert->Contact->Preferred Language Code field. For real-time, the S_CONTACT.PREF_LANG_ID is populated via the SwiPersonIO->Contact->Preferred Language Code.
Given the way the join is configured/defined, when it (the join) is resolved no language record is found because it expects a ROW_ID to be provided. My question is whether or not anything will break by changing the OOTB join specification to use the following: