Home » RDBMS Server » Server Utilities » Load from different files to one table
Load from different files to one table [message #69509] Wed, 23 January 2002 16:39 Go to next message
diaz
Messages: 58
Registered: October 2001
Member
Hello,

i'd like to ask if there's anyway to load to one table but some of the fields is loaded from one file and other fields is loaded from another file.. and how to manage checking for loading them.. well, for example is like this :

file #1 contains :
01 myname myage
02 yourname yourage

file #2 contains :
01 myname mysalary
02 yourname yoursalary

how can i manage that it would insert them in a table that has the fields (those file is separated because resulted from different division):

id,name,age,salary

can you tell me how to work this out ?

thanks
Re: Load from different files to one table [message #69528 is a reply to message #69509] Sun, 27 January 2002 09:32 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
it is better to load into staging tables and process that data using stored procedures.

look at this posting, it may help you

http://www.orafaq.net/msgboard/serverutil/messages/3367.htm
Previous Topic: Problem with sqlloader
Next Topic: oracle
Goto Forum:
  


Current Time: Sun Dec 22 21:14:48 CST 2024