Java Transformation in Informatica with Example

Java Transformation in Informatica , is a connected and active /Passive transformation which provides a simple native programming interface to define transformation functionality with the Java programming language. You can use Java transformation in Informatica to quickly define simple or moderately complex transformation functionality without advanced knowledge of the Java programming language or an external Java development environment Must read : check more about Informatica Naming convention

Few of the sample scenarios are as follows:

• A Java transformation contains two input ports that represent a start date and an end date. You can generate an output row for each date between the start date and end date.
•  you can define transformation logic to loop through input rows and generate multiple output rows based on a specific condition.

Must check : Please also check how to create Aggregator Transformation Java Transformation: A very good example of Active Java transformation can be found here Extra read: Problem :  Create a Informatica mapping to convert subject wise marks (populated in different rows) for student  into  a single row for each student with marks in a separate column for each subject.

Source Data:

STUDENT_MARKS Table Data

STUDENT_NO	SUBJECT	MARKS
1	Math	87
1	Eng	66
1	Science	78
2	Math	45
2	Eng	64
2	Science	55
3	Math	46
3	Eng	89
4	Science	86

Target Data:

STUDENT_MARK_NEW :

STUDENT	MATH_MARK	SCIENCE_MARK	ENG_MARK
1	87	78	66
2	45	55	64
3	46	NULL	89
4	NULL	86	NULL

See solution here