Re: ANYONE used OWB9.2 to load flat files???
- 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
--- In OracleWarehouseBuilder@yahoogroups.com, one oz
> --- 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
> 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