title: INFORMATICA Using transformation to get desired target from a single flat file (see pictures)
body: <p>I just started out using Informatica and currently I am figuring out how to get this to a target output (flat file to Microsoft SSIS):</p>
  
  <pre><code>    ID     Letter    Parent_ID
     ----    ------    ---------
       1       A         NULL
       2       B          1
       3       C          1
       4       D          2
       5       E          2
       6       F          3
       7       G          3
       8       H          4
       9       I          4
  </code></pre>
  
  <p>From (assuming that this is a comma-delimited flat file):</p>
  
  <pre><code>c1,c2,c3,c4
  A,B,D,H
  A,B,D,I
  A,B,E
  A,C,F
  A,C,G
  </code></pre>
  
  <p>EDIT: Where c1 c2 c3 and c4 being a header.</p>
  
  <p>EDIT: A more descriptive representation of what I want to acheive:</p>
  
  <p><img src="https://i.stack.imgur.com/MhSZU.png" alt="enter image description here"></p>
  
  <p>EDIT: Here is what I have so far (Normalizer for achieving the letter column and Sequence Generator for ID)</p>
  
  <p><img src="https://i.stack.imgur.com/SYu1I.png" alt="enter image description here"></p>
  
  <p>Thanks in advance.</p>