Search code examples
mappinginformaticafield-names

Handle field with same names but different table in Mapping

I have the following SQL:

select zcactcls.name "ACCOUNT_CLASS",
zcpatcls.name "PATIENT_CLASS",
zcsvc.name "SERVICE"

The name field is used multiple times by different tables.  In the joiner, the fields are noted as name, name1, name2.  It is hard to figure out which of these name fields belong to which table.  How can I alias these name fields to be "Account_Class", "Patient_Class", and "Service" within the mapping. 

Multiple Name Fields

Solution

  • Just rename the ports - right after the Source Qualifier. Or if you use SQL Override, simply use SQL aliases and name the ports properly right in the Source Qualifier.