Synchronizing Columns with Text Data Files or IQDs

As the modeler, you must ensure that the columns in your model reflect the current state of your data sources. You can quickly resynchronize your model columns after a data update if your model uses a single query based on a text data file or an IQD,

Procedure

  1. In the Data Sources list, select the query whose columns you want to modify, and from the Tools menu, click Modify Columns.
  2. For data source items that do not appear as columns in the model, select the items in the Source list and click Add.
  3. For columns that you want to remove from the model, select the columns in the Model list and click Remove.
  4. For unmatched columns identified by a plus sign (+) in the Matched to Source column in the Model list, do one of the following:
    • To manually match query items to columns, select a data source item in the Source list and a column in the model, and click Match.
    • To allow Cognos® Transformer to automatically match query items to columns, click Auto Match. Review any messages that appear and click OK.

Results

Data source items are now synchronized with the model.