Table of Contents

Search

  1. Preface
  2. Product Overview
  3. Before You Begin
  4. Tutorial Lesson 1
  5. Tutorial Lesson 2
  6. Tutorial Lesson 3
  7. Tutorial Lesson 4
  8. Tutorial Lesson 5
  9. Tutorial Lesson 6
  10. Naming Conventions
  11. Glossary

Getting Started

Getting Started

Creating a Filter Transformation

Creating a Filter Transformation

The Filter transformation filters rows from a source. If you connect a Filter transformation to a Source Qualifier transformation, you can filter rows passed through the Source Qualifier transformation using any condition you want to apply. In this exercise, you remove discontinued items from the mapping.
The mapping contains a Filter transformation that limits rows queried from the ITEMS table to those items that have not been discontinued.
  1. Create a Filter transformation and name it FIL_CurrentItems.
  2. Drag the following ports from the Source Qualifier transformation into the Filter transformation:
    • ITEM_ID
    • ITEM_NAME
    • PRICE
    • DISCONTINUED_FLAG
  3. Open the Filter transformation.
  4. Click the
    Properties
    tab to specify the filter condition.
  5. Click
    Open
    in the Filter Condition field.
    The
    Expression Editor
    dialog box appears.
  6. Select the word TRUE in the Formula field and press
    Delete
    .
  7. Click the
    Ports
    tab.
  8. Enter
    DISCONTINUED_FLAG = 0
    to remove discontinued items from the mapping.
  9. Click
    Validate
    , and then click
    OK
    .
    The new filter condition now appears in the Value field.
  10. Click
    OK
    to return to the workspace.

0 COMMENTS

We’d like to hear from you!