This discussion is archived
3 Replies Latest reply: Apr 2, 2013 3:46 AM by Venkat.Kh RSS

regarding files

ksbabu Newbie
Currently Being Moderated
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
    vp_ora Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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.

Legend

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