Selecting a Target Destination

Selecting a Target Destination involves selecting a target file for an appropriate database. The designer has a few choices to make in this section.

  1. Where will the output go?
  2. Will it go to a new table?
  3. Will it go to an existing table?
  4. If it goes to an existing table, can the existing table be altered in case the transform has been changed?

All of these issues are addressed by the Target Window below. In many cases the default can be chosen, and the NEXT button can be selected, but the designer has the ability to select a different target database, owner, and table name, in addition to deciding to route the output to a new/existing table.

datasynctransformtargettab.bmp

 

 

When the selection has been made, the third step in creating Transformation, Column Mapping will be performed.