2 Replies Latest reply: Jan 7, 2013 7:13 AM by user12236189 RSS

    LOAD CSV file to oracle

    user12236189
      Hi,

      How do I do the reverse engineering on the source file in Model, it's not going thru, could you please let me know if there is a link or steps for that.
      I would really appreciate your help.

      Thanks,
        • 1. Re: LOAD CSV file to oracle
          Bhabani Ranjan
          refer this
          http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/odi/odi_11g/odi_project_flatfile-to-table/odi_project_flatfile-to-table.htm

          Bhabani
          • 2. Re: LOAD CSV file to oracle
            user12236189
            Thanks, Bhabani.

            I had this link but unable to create/files in the model. I am looking for this step like data store as well as model for filles.
            I could not able to do the reverse engineering, it says that file not found.
            Does that mean I need to create all columns in Model data store, just wants to confirm that I am in right direction


            Also, how do I change the file name dynamically, as I get files everyday with different name, is this possible in ODI interface or package.

            Thanks,