6 Replies Latest reply on Sep 13, 2019 5:30 AM by inuser479910

    Append data from 2 flat files into one target flat file

    inuser479910 New Member

      Hello,

       

      I am trying to append data from 2 flat files and create one flat file target. The data looks like below:

       

      1st flat file

      <Record>

      SSN          YYY YY YYYY

      Name        AAAA

      Address     123 ABCD

      Phone        XXXXXXXXXX

      <Record>

      SSN          AAA AA AAAA

      Name        BBBB

      Address     145 GHJL

      Phone        XXXXXXXXXX

       

      2nd Flat file

      <Record>

      SSN           YYY YY YYYY

      Salary         $12000

      Comm         $1000   

      <Record>

      SSN           AAA AA AAAA

      Salary         $11000

      Comm         $2000 

       

      The target file will be created based on the below join condition.

      1st file SSN= 2nd file SSN

      The target File will look like below:

      <Record>

      SSN          YYY YY YYYY

      Name        AAAA

      Address     123 ABCD

      Phone        XXXXXXXXXX

      Salary         $12000

      Comm         $1000

      <Record>

      SSN          AAA AA AAAA

      Name        BBBB

      Address     145 GHJL

      Phone        XXXXXXXXXX

      Salary         $11000

      Comm         $2000 

       

      Can someone please help me figure out how to do this in Informatica?

       

      Thanks,

      R R