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

Transformation Descriptions

Transformation Descriptions

The following table provides a brief description of each transformation:
Transformation
Type
Description
Aggregator
  • Active
  • Connected
  • Native
Performs aggregate calculations.
Application Source Qualifier
  • Active
  • Connected
  • Non-native
Represents the rows that the Integration Service reads from an application, such as an ERP source, when it runs a session.
Custom
  • Active or Passive
  • Connected
  • Non-native
Calls a procedure in a shared library or DLL.
Data Masking
  • Passive
  • Connected
  • Non-native
Replaces sensitive production data with realistic test data for non-production environments.
Expression
  • Passive
  • Connected
  • Native
Calculates a value.
External Procedure
  • Passive
  • Connected or Unconnected
  • Native
Calls a procedure in a shared library or in the COM layer of Windows.
Filter
  • Active
  • Connected
  • Native
Filters data.
HTTP
  • Passive
  • Connected
  • Non-native
Connects to an HTTP server to read or update data.
Input
  • Passive
  • Connected
  • Native
Defines mapplet input rows. Available in the Mapplet Designer.
Java
  • Active or Passive
  • Connected
  • Non-native
Executes user logic coded in Java. The byte code for the user logic is stored in the repository.
Joiner
  • Active
  • Connected
  • Native
Joins data from different databases or flat file systems.
Lookup
  • Active or Passive
  • Connected or Unconnected
  • Native
Look up and return data from a flat file, relational table, view, or synonym.
Normalizer
  • Active
  • Connected
  • Native
Source qualifier for COBOL sources. Can also use in the pipeline to normalize data from relational or flat file sources.
Output
  • Passive
  • Connected
  • Native
Defines mapplet output rows. Available in the Mapplet Designer.
Rank
  • Active
  • Connected
  • Native
Limits records to a top or bottom range.
Router
  • Active
  • Connected
  • Native
Routes data into multiple transformations based on group conditions.
Sequence Generator
  • Passive
  • Connected
  • Native
Generates primary keys.
Sorter
  • Active
  • Connected
  • Native
Sorts data based on a sort key.
Source Qualifier
  • Active
  • Connected
  • Native
Represents the rows that the Integration Service reads from a relational or flat file source when it runs a session.
SQL
  • Active or Passive
  • Connected
  • Non-native
Executes SQL queries against a database.
Stored Procedure
  • Passive
  • Connected or Unconnected
  • Native
Calls a stored procedure.
Transaction Control
  • Active
  • Connected
  • Native
Defines commit and rollback transactions.
Union
  • Active
  • Connected
  • Non-native
Merges data from different databases or flat file systems.
Unstructured Data
  • Active or Passive
  • Connected
  • Non-native
Transforms data in unstructured and semi-structured formats.
Update Strategy
  • Active
  • Connected
  • Native
Determines whether to insert, delete, update, or reject rows.
XML Generator
  • Active
  • Connected
  • Native
Reads data from one or more input ports and outputs XML through a single output port.
XML Parser
  • Active
  • Connected
  • Native
Reads XML from one input port and outputs data to one or more output ports.
XML Source Qualifier
  • Active
  • Connected
  • Native
Represents the rows that the Integration Service reads from an XML source when it runs a session.
When you build a mapping, you add transformations and configure them to handle data according to a business purpose. Complete the following tasks to incorporate a transformation into a mapping:
  1. Create the transformation.
    Create it in the Mapping Designer as part of a mapping, in the Mapplet Designer as part of a mapplet, or in the Transformation Developer as a reusable transformation.
  2. Configure the transformation.
    Each type of transformation has a unique set of options that you can configure.
  3. Link the transformation to other transformations and target definitions.
    Drag one port to another to link them in the mapping or mapplet.