Table of Contents

Search

  1. Preface
  2. Working with Transformations
  3. Aggregator Transformation
  4. Custom Transformation
  5. Custom Transformation Functions
  6. Data Masking Transformation
  7. Data Masking Examples
  8. Expression Transformation
  9. External Procedure Transformation
  10. Filter Transformation
  11. HTTP Transformation
  12. Identity Resolution Transformation
  13. Java Transformation
  14. Java Transformation API Reference
  15. Java Expressions
  16. Java Transformation Example
  17. Joiner Transformation
  18. Lookup Transformation
  19. Lookup Caches
  20. Dynamic Lookup Cache
  21. Normalizer Transformation
  22. Rank Transformation
  23. Router Transformation
  24. Sequence Generator Transformation
  25. Sorter Transformation
  26. Source Qualifier Transformation
  27. SQL Transformation
  28. Using the SQL Transformation in a Mapping
  29. Stored Procedure Transformation
  30. Transaction Control Transformation
  31. Union Transformation
  32. Unstructured Data Transformation
  33. Update Strategy Transformation
  34. XML Transformations

Transformation Guide

Transformation Guide

Source Qualifier Transformation Overview

Source Qualifier Transformation Overview

When you add a relational or a flat file source definition to a mapping, you need to connect it to a Source Qualifier transformation. The Source Qualifier transformation represents the rows that the Integration Service reads when it runs a session. The Source Qualifier transformation is an active transformation.
Use the Source Qualifier transformation to complete the following tasks:
  • Join data originating from the same source database.
    You can join two or more tables with primary key-foreign key relationships by linking the sources to one Source Qualifier transformation.
  • Filter rows when the Integration Service reads source data.
    If you include a filter condition, the Integration Service adds a WHERE clause to the default query.
  • Specify an outer join rather than the default inner join.
    If you include a user-defined join, the Integration Service replaces the join information specified by the metadata in the SQL query.
  • Specify sorted ports.
    If you specify a number for sorted ports, the Integration Service adds an ORDER BY clause to the default SQL query.
  • Select only distinct values from the source.
    If you choose Select Distinct, the Integration Service adds a SELECT DISTINCT statement to the default SQL query.
  • Create a custom query to issue a special SELECT statement for the Integration Service to read source data.
    For example, you might use a custom query to perform aggregate calculations.

0 COMMENTS

We’d like to hear from you!