Skip to main content

Map sources, targets and mappings

A Map inherits a source and destination Definition reference and stores view/field mapping items against those structures. Stable Definition identities and names are therefore part of the Map contract.

Module and mapping properties

SettingDefaultEffect
Source type / DefinitionNo sourceDB/File type and SourceFIDS reference opened for read.
Destination type / DefinitionNo destinationDB/File type and DestFIDS reference opened for mapped output.
InitialisedClearedPersists whether the Map design has been initialised/synchronised. Do not edit it manually.
Use XSI nil for nullsClearedMap-level null-output choice used for applicable XML/JSON destination behaviour; test against the destination contract.
Save dataRuntime reset to selectedControls applicable destination save behaviour during execution. It is runtime state rather than a normal setup checkbox in the saved Map contract.
View description/mappingPer destination viewAssociates a destination dataview with its source and owns view events/record counters.
Field name/typePer destination fieldIdentifies the destination field and Velox field type; source comment confirms matching is by field name rather than a live field-object reference.

Design procedure

  1. Select tested source and destination Definitions.
  2. Open Map and reconcile every destination view with the intended source view.
  3. For master/detail data, map parent/child relationships before individual fields.
  4. Map required keys and destination fields; leave a field unmapped only when the destination default/null rule is deliberate.
  5. Verify data types, size/truncation, nulls, dates/time zones, decimal precision and repeated records.
  6. Preserve the current Map before accepting a Definition synchronisation/reset.

Changing or renaming a Definition field can orphan a field-name mapping even when the module FID remains valid. Reopen, compile, preview and run an isolated persisted test after any Definition change. See expressions and validation and runtime troubleshooting.