Table of Contents

Search

  1. Preface
  2. Introduction to Transformations
  3. Transformation Ports
  4. Transformation Caches
  5. Address Validator Transformation
  6. Aggregator Transformation
  7. Association Transformation
  8. Bad Record Exception Transformation
  9. Case Converter Transformation
  10. Classifier Transformation
  11. Comparison Transformation
  12. Consolidation Transformation
  13. Data Masking Transformation
  14. Data Processor Transformation
  15. Decision Transformation
  16. Duplicate Record Exception Transformation
  17. Expression Transformation
  18. Filter Transformation
  19. Hierarchical to Relational Transformation
  20. Java Transformation
  21. Java Transformation API Reference
  22. Java Expressions
  23. Joiner Transformation
  24. Key Generator Transformation
  25. Labeler Transformation
  26. Lookup Transformation
  27. Lookup Caches
  28. Dynamic Lookup Cache
  29. Match Transformation
  30. Match Transformations in Field Analysis
  31. Match Transformations in Identity Analysis
  32. Normalizer Transformation
  33. Merge Transformation
  34. Parser Transformation
  35. Python Transformation
  36. Rank Transformation
  37. Read Transformation
  38. Relational to Hierarchical Transformation
  39. REST Web Service Consumer Transformation
  40. Router Transformation
  41. Sequence Generator Transformation
  42. Sorter Transformation
  43. SQL Transformation
  44. Standardizer Transformation
  45. Union Transformation
  46. Update Strategy Transformation
  47. Web Service Consumer Transformation
  48. Parsing Web Service SOAP Messages
  49. Generating Web Service SOAP Messages
  50. Weighted Average Transformation
  51. Window Transformation
  52. Write Transformation
  53. Appendix A: Transformation Delimiters

Developer Transformation Guide

Developer Transformation Guide

Java Transformation Advanced Properties

Java Transformation Advanced Properties

The Java transformation includes advanced properties for both the transformation code and the transformation.
When you use the transformation in a mapping, you can override the transformation properties.
You can define the following advanced properties for the Java transformation on the
Advanced
tab:
Tracing Level
Amount of detail that appears in the log for this transformation. You can choose terse, normal, verbose initialization, or verbose data. Default is normal.
Partitionable
The transformation can be processed with multiple threads. Clear this option if you want the Data Integration Service to use one thread to process the transformation. The Data Integration Service can use multiple threads to process the remaining mapping pipeline stages.
Disable partitioning for a Java transformation when the Java code requires that the transformation be processed with one thread.
Enable high precision
Processes a decimal data type port with a precision less than or equal to 38 as a Java BigDecimal data type port.
Disable high precision to process a decimal data type port as a Java Double data type port.
The following table shows how a Java transformation treats a value in a decimal data type input port based on whether you have enabled or disabled the high precision option:
Example
High Precision Processing Enabled
High Precision Processing Disabled
A decimal type input port receives a value of 40012030304957666903.
The Java transformation leaves the value as is.
The Java transformation converts the value to the following value:
4.00120303049577 x 10^19
If the Java transformation contains a decimal port or a complex port with an element of a decimal data type, the transformation must use the same precision mode as the mapping. For example, if you enable high precision in the Java transformation, you must enable high precision in the mapping.
Use nanoseconds in
Date/Time
Converts
date/time
datatype ports to Java BigDecimal datatype ports with nanosecond precision.
Disable nanosecond processing so that the generated Java code converts
date/time
datatype ports to Java Long datatype ports with millisecond precision.
Classpath
Sets the classpath for jar or class file directories that are associated with non-standard Java packages that you import on the
Imports
tab.
The jar or class file directories must be accessible on the Developer tool client machine for compilation of the Java code.
Based on the operating system, separate classpath entries as follows:
  • On UNIX, use a colon to separate classpath entries.
  • On Windows, use a semicolon to separate classpath entries.
For example, if you import the Java converter package on the
Imports
tab and you define the package in converter.jar, you must add the location of the converter.jar file to the classpath before you compile the Java code for the Java transformation.
You do not need to set the classpath for built-in Java packages. For example, because java.io is a built-in Java package, you do not need to set the classpath for java.io.
Is Active
Indicates whether the transformation is an active transformation. An active transformation can change the number of rows that pass through it.
You cannot change this property after you create the transformation. If you need to change this property, create a new transformation.
Transformation Scope
Defines the method that the Data Integration Service uses to apply the transformation logic to incoming data. You can choose one of the following values:
  • Row. Applies the transformation logic to one row of data at a time. Choose Row when the results of the procedure depend on a single row of data.
  • Transaction. Applies the transformation logic to all rows in a transaction. Choose Transaction when the results of the procedure depend on all rows in the same transaction, but not on rows in other transactions. When you choose Transaction, you must connect all input groups to the same transaction control point.
  • All Input. Applies the transformation logic to all incoming data. when you choose All Input, the Data Integration Service drops transaction boundaries. Choose All Input when the results of the procedure depend on all rows of data in the source.
Stateless
Maintain the row order of the input data to the transformation. Select this option if the Data Integration Service should not perform any optimization that can change the row order.
When the Data Integration Service performs optimizations, it might lose an order established earlier in the mapping. You can establish order in a mapping with a sorted flat file source, a sorted relational source, or a Sorter transformation. When you configure a transformation to maintain row order, the Data Integration Service considers this configuration when it performs optimizations for the mapping. The Data Integration Service performs optimizations for the transformation if it can maintain the order. The Data Integration Service does not perform optimizations for the transformation if the optimization would change the row order.

0 COMMENTS

We’d like to hear from you!