Configuring a Lookup Transformation

Configuring a Lookup Transformation

Configure a Lookup transformation to look up data in an HBase resource.
  1. Open a mapping from the
    Object Explorer
    view.
  2. From the
    Object Explorer
    view, drag an HBase data object read operation to the mapping editor.
    The
    Add to Mapping
    dialog box appears.
  3. Select
    Lookup
    to add the data object read operation as a Lookup transformation to the mapping.
  4. Select the HBase data object read operation and connect the lookup input ports and the lookup output ports.
  5. In the
    Properties
    view, configure the following parameters:
    1. On the
      General
      tab, select the option that you want the Data Integration Service to return when it finds multiple rows that match the lookup condition.
    2. On the
      Ports
      tab, configure the output ports and input rules.
    3. On the
      Run-time
      tab, enable lookup caching if required.
    4. On the
      Lookup
      tab, configure the lookup condition.
  6. When the mapping is valid, click
    File
    Save
    to save the mapping to the Model repository.
  7. Run the mapping in the native environment or on the Spark engine to look up data in an HBase resource.