Add or Refresh Columns Displayed in a Target Object

You may need to load data for a column that exists in a target object in your target application, but isn't already populated by your current tasks and data flows.

  • In your project you have identified the task and data flow that you need to modify.

  • The target object already contains the additional column needed to meet your requirements.

  • If your target is a file format, from the Datastores tab, add additional columns to the file format.

To refresh columns displayed in an existing target object in a data flow:

  1. If the column does not display in the target object, reimport the target object:
    1. From the Datastores tab, select the datastore which contains your target object.
    2. Select the Import Objects icon.
    3. Select the object you want to reimport.
    4. Select Import.
    Note
    If your target is a file format, columns added to the file format are automatically reflected in the Output pane of the Target Query.
  2. From the Projects tab, select the task you want edit and select Edit.
  3. Select the relevant data flow and select Edit.
  4. In the final transform, locate the new column.
    Tip
    The new column has not yet been mapped and thus will not have a mapped icon in the mapping column.
  5. Beginning at the upstream step in your data flow where the source object needed for the new column is introduced, propagate the column through the interim transforms.
    As needed, edit the mappings or add additional transforms to the data flow.
  6. In the Target Query transform, map the column from the Input to Output panes.