This discussion is archived
2 Replies Latest reply: Jan 7, 2013 5:13 AM by user12236189 RSS

LOAD CSV file to oracle

user12236189 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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,

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points