3 Replies Latest reply: Apr 2, 2013 5:46 AM by Venkat.Kh RSS

    regarding files

    ksbabu
      Hi Experts,

      i am new to odi,my requirement is i have 5 flat files with different structure each file contain some records
      how can i load into target,this is urgent please help me


      Regards
      sateesh
        • 1. Re: regarding files
          vai
          what exactly are you trying to achieve?
          5 different files to 5 different tables or
          5 different files into single table?
          • 2. Re: regarding files
            JeromeFr
            Hi Sateesh,

            I advise you to follow the "Oracle By Example" tutorials : Re: How to speed up ODI server

            This one explain how to load from files to Oracle database : http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/odi/odi_11g/odi_project_flatfile-to-table/odi_project_flatfile-to-table.htm
            You might need to follow this one first to understand how to connect the flat files : http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/odi/odi_11g/odi_project_ff-to-ff/odi_project_flatfile-to-flatfile.htm

            Regards,
            JeromeFr

            ps : Don't forget to review your older questions, you got answers and didn't replied nor mark as resolved.
            • 3. Re: regarding files
              Venkat.Kh
              Hi Sateesh,

              First you can give me the structure of your flat files say they are of same heading or different ?

              If same you will work with variables, if not you can merge those files into single then load....

              Cheers.