Table of Contents

Search

  1. Preface
  2. Transformations
  3. Source transformation
  4. Target transformation
  5. Aggregator transformation
  6. Cleanse transformation
  7. Data Masking transformation
  8. Deduplicate transformation
  9. Expression transformation
  10. Filter transformation
  11. Hierarchy Builder transformation
  12. Hierarchy Parser transformation
  13. Hierarchy Processor transformation
  14. Input transformation
  15. Java transformation
  16. Java transformation API reference
  17. Joiner transformation
  18. Labeler transformation
  19. Lookup transformation
  20. Mapplet transformation
  21. Normalizer transformation
  22. Output transformation
  23. Parse transformation
  24. Python transformation
  25. Rank transformation
  26. Router transformation
  27. Rule Specification transformation
  28. Sequence Generator transformation
  29. Sorter transformation
  30. SQL transformation
  31. Structure Parser transformation
  32. Transaction Control transformation
  33. Union transformation
  34. Velocity transformation
  35. Verifier transformation
  36. Web Services transformation

Transformations

Transformations

Database source properties

Database source properties

Configure properties for database sources such as the database connection, source type, and source objects. You can also specify filter and sort conditions, pre- and post-SQL commands, and whether the output is deterministic or repeatable.
The following table describes the database source properties:
Property
Description
Connection
Name of the source connection.
Source Type
Source type.
Object
Source object for a single source.
Add Source Object
Primary source object for multiple sources.
Add Related Objects
For multiple sources. Displays objects related to the selected source object.
Select an object with an existing relationship or click
Custom Relationship
to create a custom relationship with another object.
Filter
Adds conditions to filter records. Configure a simple or an advanced filter.
Sort
Adds conditions to sort records.
Select Distinct Rows Only
Reads unique rows from the source. Adds SELECT DISTINCT to the SQL query.
Define Query
For a custom query. Displays the
Edit Custom Query
dialog box. Enter a valid custom query and click
OK
.
Tracing Level
Detail level of error and status messages that
Data Integration
writes in the session log. You can choose terse, normal, verbose initialization, or verbose data. Default is normal.
Pre SQL
SQL command to run against the source before reading data from the source.
You can enter a command of up to 5000 characters.
Post SQL
SQL command to run against the source after writing data to the target.
You can enter a command of up to 5000 characters.
SQL Query
SQL query to override the default query that
Data Integration
uses to read data from the source. You can enter an SQL statement supported by the source database.
Output is deterministic
Relational source or transformation output that does not change between mapping runs when the input data is consistent between runs.
When you configure this property, the Secure Agent does not stage source data for recovery if transformations in the pipeline always produce repeatable data.
Output is repeatable
Relational source or transformation output that is in the same order between session runs when the order of the input data is consistent.
When output is deterministic and output is repeatable, the Secure Agent does not stage source data for recovery.