title: Informatica Mapping to create Target File of Mainframe File Layout
body: <p>I am looking for suggestions, on how this requirement be approached.
  I have to come-up with Informatica mapping to construct below Target File.</p>
  
  <p>Source File</p>
  
  <pre>
  Key-1 Key-2 ACCOUNT-1
  Key-1 Key-2 ACCOUNT-2
  Key-1 Key-2 CC-ACC-1
  Key-1 Key-2 CC-ACC-2
  Key-1 Key-2 CC-ACC-3
  
  </pre>
  
  <p>For the above input source layout, I need to have one output record based on below Target File.</p>
  
  <p>Basically, I need to group the data based on Key-1 &amp; Key-2 Field &amp; create a record that can have more than one accounts &amp; more than one credit card account details for a customer.</p>
  
  <p>TARGET FILE &lt;&lt; MAINFRAME FILE LAYOUT >></p>
  
  <pre> 
  
  Key-1   String 10
  Key-2   String 10
  BANK-CUSTOMER-INFO
      MGR-NAME    STRING 50   — data to be extracted from MGR Table
      MGR-EMAIL   STRING 100  — data to be extracted from MGR-ADDTNL-INFO Table
      MGR-PHNE    STRING 10   — data to be extracted from MGR-ADDTNL-INFO Table
      CUST-NAME   STRING 100  — data to be extracted from Person Table
      CUST-EMAIL  STRING 100  — data to be extracted from Person-Addtnl_info Table
  CUST-ACCOUNT-INFO
      BANK-ACCOUNT OCCURS 5 TIMES
          ACC-NO      STRING 10           ( Key Field )
          ACC-TYPE    STRING 10       — data to be extracted from  A Table
          ACC-TRXN-DTLS   OCCURS 10 TIMES
              ACC-TRXN-DATE   DATE 10     — data to be extracted from  X Table
              ACC-TRXN-MODE   STRING 10   — data to be extracted from Y Table
              ACC-TRXN-AMT    STRING 10   — data to be extracted from Z Table
      CREDIT-CARD-ACC OCCURS 5 TIMES
          CC-ACC-NO       STRING 10       ( Key Field )
          CC-ACC-TYPE     STRING 10   — data to be extracted from  B Table
          CC-TRXN-DTLS    OCCURS 10 TIMES
              CC-TRXN-DATE    DATE 10     — data o be extracted from  X1 Table
              CC-TRXN-MODE    STRING 10   — data o be extracted from  Y2 Table
              CC-TRXN-AMT STRING 10   — data o be extracted from  Z2 Table
  
  </pre>
  
  <p>Questions :-</p>
  
  <pre>
  How mapping can be accomplished.
  Does Informatica supports to have Target Structure as defined above.
  Most of my Target Attributes are to be fetched from multiple tables to construct one record, what should be most efficient way to come with Mapping.
  Also, I need to denormalise the data as well to get above structure.
  </pre>