Modeling Guide

Data Target

Data Target nodes provide connections to the output data.

Prerequisites

You have added the Data Target node to the canvas, connected the previous node, and clicked the Configure (gear) icon.

Context

There are two ways to include a Data Target node in your flowgraph. When creating a new flowgraph, there is a Target option above the canvas where you can select the target object. The other method is by selecting the + icon on the canvas and selecting Data Target.

Procedure

  1. Click Select Dataset and choose one of your defined data sets.
  2. Map the input column names to the output columns by selecting the appropriate column under the Mapping Column or choosing one of the following auto-mapping options.
    • By Index: Maps the columns by the position they appear in the input and output objects.
    • By Name: Maps the columns by matching the column names.
  3. (Optional) Click + to define additional columns. Select a datatype. Under the Primary Key column, select a column that serves as the primary key. Typically the data in this column is unique. Choose whether the column value can be empty (nullable).
  4. (Optional) To reorder the columns, click the up and down arrow icon. Select the column that you want to move and click the up or down arrows. Click Apply.
  5. When you have finished configuring the node, click Apply to return to the canvas.