IICS | Java transformation (Active/Passive) | #informatica смотреть онлайн

Java Transformation
1. With basic knowledge in java we can write simple/medium level of code to handle transformation. With advance knowledge you write complex logic as well.
2. In our today’s example we can work out on Passive/Active transformation.
3. Passive: Rows pass through between Source/Target does not change.
1. Source - EMP Table
2. Create target table as T_EMP_JAVA using EMP table.
3. Java transformation - Properties/Incoming fields Rule - to bring only 3 columns under Java transformation
1. EMPNO, ENAME and SAL
4. Java transformation - Properties/Output fields defined
5. Java transformation - Properties/Java Editor
On Input Row
O_EMPNO = EMPNO;
O_ENAME = ENAME;
O_SAL = SAL;
5. Target - Field map Output fields from Java to Target
6. Finally, run the job and verify the results ie. 14 source/target records read/write properly
1. Active: Rows pass through between Source/Target does changes due to rows filter not qualify the business rules.
1. Source - EMP Table
2. Java transformation - Properties/Incoming fields Rule - to bring only 3 columns under Java transformation
1. EMPNO, ENAME and SAL
3. Java transformation - Properties/Output fields defined
4. Java transformation - Properties/Java Editor
On Input Row
if SAL lesser than 1600
O_EMPNO = EMPNO;
O_ENAME = ENAME;
O_SAL = SAL;
generateRow;

5. Target - Field map Output fields from Java to Target
6. Finally, run the job and verify the results ie. 14 source/target records read/write properly