The Field-Mapping Workbook is one of the key deliverables produced by MDA Workbench.
The list of fields that appear on each worksheet of the Field-Level Mapping Workbook can be configured using Field Manager, which is available on the View Ribbon of the main toolbar.
Using Field Manager to maintain the configuration for Field-Mapping Workbook serves two purposes:
There is only one Field Manager mapping to be maintained for both purposes.
Here are the relevant Field Manager Objects:
Worksheet |
Field Manager Object(s) |
MapSgements MapFields |
|
StagingTableSchemaProject StagingTable StagingTableSchemaSegment StagingTableSchemaField StagingTableSchemaSQL |
|
ValidationTest |
For each Field Manager Objects, for each Property there is a Behavior property.
Object Property |
Comment |
Behavior |
|
Publish Field-Mapping Workbook
Option 1 - Verbose (No Longer Available as of version 1.0.0.118)
The Field-Mapping Workbook contains the following worksheets:
Worksheet |
Comment |
PROJECT |
|
Sap Field Map |
|
SCHEMA |
|
DATA |
|
Option 2 - Consolidated
The Field-Mapping Workbook contains the following worksheets:
Worksheet |
Comment |
PROJECT |
|
Sap Field Map |
|
DATA |
|
Transfer Data from Field-Mapping Workbook