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

On Input Tab

On Input Tab

On the
On Input
tab, you define how an active or passive Java transformation behaves when it receives an input row. On this tab, you can also access and use input and output port data, variables, and Java transformation API methods.
The Java code that you define on this tab runs one time for each input row.
To define how a Java transformation behaves when it receives an input row, enter the code in the
Java code
window in the
Code
properties on the
On Input
tab.
From the navigator on the
On Input
tab, you can access and define the following variables and API methods:
  • Input port and output port variables. Access input and output port data as a variable by using the name of the port as the name of the variable. For example, if “in_int” is an Integer input port, you can access the data for this port by referring as a variable “in_int” with the Java primitive datatype int. You do not need to declare input and output ports as variables.
    Do not assign a value to an input port variable. If you assign a value to an input variable on the
    On Input
    tab, you cannot get the input data for the corresponding port in the current row.
  • Instance variables and user-defined methods. Use any instance or static variable or user-defined method you declared on the
    Helpers
    tab.
    For example, an active Java transformation has two input ports, BASE_SALARY and BONUSES, with an integer datatype, and a single output port, TOTAL_COMP, with an integer datatype. You create a user-defined method on the
    Helpers
    tab, myTXAdd, that adds two integers and returns the result. Use the following Java code in the
    On Input
    tab to assign the total values for the input ports to the output port and generate an output row:
    TOTAL_COMP = myTXAdd (BASE_SALARY,BONUSES); generateRow();
    When the Java transformation receives an input row, it adds the values of the BASE_SALARY and BONUSES input ports, assigns the value to the TOTAL_COMP output port, and generates an output row.
  • Java transformation API methods. You can call API methods provided by the Java transformation.
To compile the code for the Java transformation, click
Compile
in the
Compilation
properties on the
On Input
tab. The results of the compilation appear in the
Results
window on the
On Input
tab.

0 COMMENTS

We’d like to hear from you!