Fusion Data Mapper - Maintaining Mapping Rules

Overview

The Fusion Data Mapper displays the Structure Mapping rules which are ultimatley maintained and retrieved from the Fusion Registry. The Data Mapper provides the ability to load in rules from Excel or CSV files, edit or delete the rules locally and save them to the Fusion Registry server.

Importing rules from Excel

Mapping rules can be expressed in an excel file by creating a column which has the same Id as the ID of the Source Dimenison, and subsequent columns with Ids that match those of the Target Dimensions or Series Attributes.

The order of the columns is not important, as long as the column headings match the Ids of the Dimensions. If the target Dataflow wants to include the Series Code, perhaps as a Series Attribute, then ensure the Series Attribute Id in the target is the same as the Id in the source, and no further mapping is required, the Series Code will be exposed via the target Dataflow. The Source Dataflow can contain other Series Attributes for example LAST_UPDATED to indidcate when the series was last updated. If the Target Dataflow has the same Series Attributes the data will be automatically mapped across without changing the reported value.

The quickest way to create an Excel file is to export the empty table in Excel format from the Data Mapper - this provides a bloank template for creating new rules.