4 Replies Latest reply on Dec 29, 2020 9:48 PM by Syed Aziz

    Repeat the second output column value based on input value

    Venkat G New Member

      Hi Guys,

      I am new to Informatica and trying to implement below scenario in my current project. I am trying to use LPAD, which is not possible as we need to pass specific length for second parameter.

       

      Here is my scenario.

       

      Source table:

      ID|Name

      1|A

      2|B

      3|c

      4|D

      ..

      ..

      ..

      100|k

       

      Output Table:

       

      ID|Name

      1|A

      2|BB

      3|CCC

      4|DDDD

      ..

      ..

      100|kkkkkkkkkkkk....100 times

       

      Please help with the solution.

      Thanks in advance...

       

      Message was edited by: Venkat G

        This content has been marked as final.  Show 4 replies