An important part of creating a DTS file is to determine which data
objects to move from the source to the target and to perform any necessary
transformation on the data during the integration. Mapping is the process
of creating links between the source and target data objects; transformation
involves creating formulas to accomplish any of a wide variety of tasks
using Insight’s rich function library.
Using Links
Workbench provides the following types of links:
Data links — A direct connection between
source and target data objects. Required for insert and update steps.
Lookup links — A link that helps locate
matching records between source and target data objects. Lookup links
are required for seek, update, and delete steps.
Fixed value links — A link on the target
data object that is derived from a formula but not associated with a source
field. Examples include system time (for timestamps) or data source name.
Auto links — Links created automatically
that match source and target fields and create data links between them.