Adding the Data Lookup component to a project

Adding Data Lookup to a project opens a property window. Use the property window to define the Key Attribute, Value Attribute, connection parameters, and query options.

The following procedure assumes that the lookup data is extracted from a text file.

StepsTo use the Data Lookup component

  1. Add the component to the project.

  2. Connect the upper IN-Port (Main) with the OUT-Port of the previous component, that will provide the data, containing the key to be looked up, to the Data Lookup component.

  3. Add a Text Data Provider component to the project.

  4. Connect the lower IN-Port (Lookup) of the Data Lookup component with the OUT-Port of the Text Data Provider component.

  5. Specify all data that is required to set up the Text Data Provider Component. Make sure that a proper column definition for the file is provided.