update data coming in flat file [message #58049] |
Mon, 28 July 2003 15:04 |
sidd
Messages: 130 Registered: May 2003
|
Senior Member |
|
|
I need to update the table with the data coming in flat file.. how do i do this.. they send the updates in flat files.. i don't think i can do using sqlloader.. is there a way? please
|
|
|
|
Re: update data coming in flat file [message #58055 is a reply to message #58052] |
Tue, 29 July 2003 01:55 |
psmyth
Messages: 81 Registered: October 2002
|
Member |
|
|
i think you both need to have a look at the oracle docs on sql*loader... you can do all those things and more with sql*loader ;-)
Whether you would want to load the data directly into the main tables is another matter - it often makes sense to follow the procedure Mahesh posted - load the data into 'staging' tables and then run a transformation on that data. It really depends on what the data is and how the application works.
But read the Oracle docs... they rock ;-)
|
|
|
|
|
|
|