Search code examples
informaticainformatica-powercenter

explain java transformation in informatica

Hi all am using a java transformation in my mapping and added the code in it

for(int i=0;i<3;i++)
{
     EMP_NAME1=">>"+EMP_NAME+"<<";
     EMP_ID1=EMP_ID;
}

I expect the rows should be inserted 3 times.

But it is done once,string concatenated with >> <<.

Also can anyone explain me what is the difference between active and passive java transformation.

I have created the passive one in any case will it be the reason?

Thanks in advance.

Solution

  • You need to call generateRow() inside the loop. Java transformation emits a new row every time this function is executed.

    Active transformations change the number of rows passing through them. On the contrary, if the number of input rows is equal to output rows, then the transformation is called passive. You should use the former.