Map or unmap a Source Term with a Target Term

To map or unmap a Source Term with a Target Term in a Dataflow Set, access the Term Mapping overview page for a Model Object:

From here, you can:

• Map a Source Term with a Target term

• Unmap a Target Term
• Auto-map all Source Terms with Target Terms
• Map a Target term to a default value

Map a Source Term with a Target term

To map a Source Term with a Target Term, several possibilities depending on the mapping option selected:

• Automatic Mapping: the Mapping is based on the Source Term name: 
  
  
  • Auto-map a Source Term with an existing Target
  • Auto-map a Source Term with a New Term

• Target Mapping: you can choose manually which Target Term you want to map to the Source Term
  
  
  • Map manually a Target Term
  • Map a Target Term with an Expression 

Auto-map a Source Term with an existing Target

To auto-map a Source Term with an existing Target Term, you can select the Auto Mapping mode:

They should have the same name.

Hover over the column Mapped for a non-mapped Source Term, and the plus icon appears:

Click on the plus icon: 

• The Source Term is mapped with the Target term using the same name. The mapped icon appears for both Source and Target terms:
  
• The Target Term Expression is automatically filled with the Source Term:
  
• A notification confirms the correct update:
  
• If you hover over the column Mapped of the Target Term, Source, and Target appear with the minus icon so you can identify them as mapped together easily:
  

Auto-map a Source Term with a new Term

To auto-map a Source Term with a new Target Term, select the Auto Mapping mode:

No Target Term with the same name as the Source Term should exist, like here for the rowguid Source Term:

Hover over the column Mapped for this non-mapped Source Term, and the plus icon appears:

Click on the plus icon: 

• A new Target Term is automatically created with the same name as the Source Term:
  
• The Source Term is mapped with the new Target term. The mapped icon appears for both Source and Target terms:
  
• The Target Term Expression is automatically filled with the Source Term:
  
• A notification confirms the correct update:
  
• If you hover over the column Mapped in the Target Term, a minus icon appears on both Source and Target so that you can identify them as mapped together easily:
  

Map a Target Term manually

To manually map a Target Term to a Source Term, select the Target Mapping mode:

Hover over the column Mapped for a Source Term, and the plus icon appears:

Click on the plus icon. The selected mode is activated for the Source Term:

Hover over the column Mapped for the desired Target Term, and the plus icon appears:

Click on the plus icon:

• The Source Term is now mapped with the Target term. The mapped icon appears for both Source and Target terms:
  
• The Target Term Expression is automatically filled with the Source Term:
  
• A notification confirms the correct update:
  
• If you hover over the column Mapped of the Target Term, Source, and Target appear with the minus icon so you can identify them as mapped together easily:
  

Map a Target Term with an Expression

To map a Target Term with an Expression, click on the Context menu of the Target Term and select the Edit Term Mapping menu:

The Edit Term Mapping side panel window is displayed.

If the Expression concerns several Terms:

• The Source Terms are mapped with the Target Term. The mapped icon appears for all Source and Target terms:
  
• The Target Term Expression is filled with the Expression we wrote:
  
• If you hover over the column Mapped of the Target Term, Sources, and Target appear with the minus icon so you can identify them as mapped together easily:
  

Unmap a Target Term

To unmap a Source Term with an existing Target Term, hover over the column Mapped for a mapped Target Term, and the minus icon appears:

Click on the minus icon: 

• The Source Term is unmapped from the Target term:
  
• A notification confirms the correct update:
  

Auto-map all Source Terms with Target Terms

To auto-map all the Source Terms with the Target terms, click on the Context menu for a Dataflow Set and choose the Auto Map All menu:

A confirmation pop-up appears:

Click on the MAP button:

• All the Source Terms with the same name as a Target term are mapped to them. If a Source Term doesn't match a Target Term name, a new Target Term is created:
  
• A notification confirms the correct update:
  

Map a Target term with a default value

To map a Target Term with a default value click on the Context menu of the Target Term and select the Edit Term Mapping menu:

The Edit Term Mapping side panel window is displayed.

Fill in a default value:

The Target Term is mapped to the default value. The mapped to default value icon appears for the Target Term:

Demonstration video