Loading ...
Sorry, an error occurred while loading the content.
 

Re: ANYONE used OWB9.2 to load flat files???

Expand Messages
  • khaleel43
    Hi Fahd, I have done some data loading from flat files to Oracle tables using OWB maps. Still if u face problems, pls do get back to me with more details. Best
    Message 1 of 7 , Mar 7, 2004
      Hi Fahd,

      I have done some data loading from flat files to Oracle tables using
      OWB maps. Still if u face problems, pls do get back to me with more
      details.

      Best Rgds
      khaleel

      --- In OracleWarehouseBuilder@yahoogroups.com, one oz
      <ozone3749@y...> wrote:
      > --- Fahd Saeed <fsaeed@s...> wrote:
      > > Hello Everyone.
      > >
      > > I got a grip load of flat files sitting on my hard
      > > disk. I have a target
      > > schema created, and have loaded OWB with the target
      > > location and all that
      > > jazz. Now when i'm drawing my map, I load the flat
      > > file wizard from the
      > > toolbox, BUT i only get the following two options
      > >
      > > * Create unbound mapping file with no attributes
      > > * Select from existing repository file and bind
      > >
      > > The following two options are not available
      > >
      > > *Create new repository file and bind
      > > *Import File into repository and bind
      > >
      > > My question is: How do I load these flat files into
      > > my OWB map? How do you
      > > load from flat files in OWB in general? Has anyone
      > > used flat files to load
      > > oracle DB using OWB? I have the option of using
      > > SQL*Loader, but wanted to
      > > give OWB a chance before leaving it for SQL*Loader.
      > > Any advice suggestion
      > > would be greatly appreciated. Thanks in advance.
      > >
      > >
      > > Regards,
      > > Fahd Saeed
      > >
      >
      > Fahd,
      >
      > I have used owb to load flat files via sql*loader
      > scripts generated by owb. also, consider using
      > external files instead. there are lots of advantages
      > to this method. it does require a v9 target database.
      > as far as the problems you are having, i would
      > recommend checking the documentation for the steps to
      > perform this operation.
      >
      > Mark Sandler
      >
      > __________________________________
      > Do you Yahoo!?
      > Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
      > http://hotjobs.sweepstakes.yahoo.com/signingbonus
    Your message has been successfully submitted and would be delivered to recipients shortly.