Update in SQL Loader

Hi

Orace 9i Datawarehouse Environment.
Transition and Production DB are on different servers.

The scenario is like this
Referring to the attachment. Patient ID  is a surogate key and it is the
primary key.
Initially for patient ID =1 the reocrd will be same in Transition and
Production.
Now when any attribute changes like Mumbai to Navi Mumbai the a new
surrogate key is generated.
Here Now in Production we see that status for PAteient ID is UPDATED to
Inactice and NEW REOCRD wih patient ID = 2 is inserted into production DB.

Now I am planning to get all record from transtion into flat files and then
load using SQL Loader as Transition and Production are on different DB.


The poblem is CAN i use Sql loader as I know it is used only to insert a
records.It does not update the records which i want.
But in the existing case sql loader  will delete the old record and then
insert the new record so history will be maintained but deletion will lead
to fragmentation which i don;t prefer as there will be millions of records.

Do you have any other alternative or is there any chance of using UPDATE
using SQL LOADER.
OR how can we make use of WHEN and decode in sql loader.

Thanks & Regards
Rajiv




Rajiv Khatri


---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to [email protected].