HomeForum
Welcome, Guest

Load data from file into two different tables within an oracle database
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: Load data from file into two different tables within an oracle database

Load data from file into two different tables within an oracle database 11 months, 2 weeks ago #2868

  • SteveK
  • OFFLINE
  • Junior Boarder
  • Posts: 32
  • Karma: 0
Hi,

I am trying to load data from my source file to two different tables within an oracle database.

In summary, my source file contains the data needed to populate two different tables. Some of this data needs to be loaded to both tables, while some data goes to one or the other table.

I am trying to pass my source file through a validation and a transformer, then into two different readers, each representing its own unique target table.
I would like to take the data that has been transformed and load it to two different tables. Is this possible?

Thanks
Steve

Re: Load data from file into two different tables within an oracle database 11 months, 2 weeks ago #2869

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2182
  • Karma: 12
You can't have several readers.
But you can have one reader and multiple writers.

Sales by Customer Example does exactly this.

John

Re: Load data from file into two different tables within an oracle database 11 months, 2 weeks ago #2870

  • SteveK
  • OFFLINE
  • Junior Boarder
  • Posts: 32
  • Karma: 0
My data does not contain a record type. Is there a way for me to split my data to multiple writers if my data does not have a record type?

Please advise.

Thanks
Steve
  • Page:
  • 1
Time to create page: 0.17 seconds

Testimonials

I just transferred 10,000,000 million records from the main SQL Anywhere database over the network into a Postgres database without a hitch.

Thank you
Thank you
Thank you

George…

!!!!! You guys rock!!!!!!!!

User Login

You only need to log in or register to use our support forum



Our customers

BP

BBC

HSBC


Databases we work with

Go to top