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

    LOAD CSV file to oracle


      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.

        • 1. Re: LOAD CSV file to oracle
          Bhabani Ranjan
          refer this

          • 2. Re: LOAD CSV file to oracle
            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.