4 Replies Latest reply on Mar 12, 2020 4:41 AM by Mohammad Abdullah

    Flat File Fixed Width

    Mohammad Abdullah New Member

      Hey

      I am working on loading data from a flat  file . the shape of data inside this file is :

      header

      OH1.....

      OH2...

      OH3

      .

      .

      OH7.....

      OR1...

      OR2....

      OR3....

      OR1...

      OR2....

      OR3....

      OH1.....

      OH2...

      OH3

      .

      .

      OH7.....

      OR1...

      OR2....

      OR3....

      footer
      The block is from oh1 to or3 (one or more )
      and also OR1 TO OR3 is also repeative ( one or more )every line has multiple fields with fixed width e.x:
      OH1:
      TAG:0-3
      ID:3-23
      NAME:23:55

       

      and  so on

       

       

      I need to represent this structure in Informatica  Cloude (data integration ) 

      I Have no idea how could i start , which component could I use to retrieve data from fixed-width flat file