Import strategie

Hi there.

I have an Oracle DB running on a Windows 2000 ADV Cluster with Oracle 8.1.7.

I have a table tblPersonalData (Description at the end) which gets its data from another system. The data is loaded into a import table once a night.

I now have to update the real table with that information. Right now I only have to update 9 columns.

I see different ways to do it:

Have a small job which is executed some time after the import started which just does an update and then delete all data in the import table

or I could do a trigger which updates the data in the real table.

The first one seems good for me. Anything against it?

How would you do it?

Here is the table:

CREATE TABLE TBLPERSONALDATA
(

  SOBJUNIQUEKEY           CHAR(10)              NOT NULL,
  SPERSONALNUMBER         VARCHAR2(10),
  SLASTNAME               VARCHAR2(40),
  SMIDNAME_OFFICIAL       CHAR(1),
  SFIRSTNAME              VARCHAR2(30),
  DDATEJOINED             DATE,
  DDATEINJOB              DATE,
  DDATELEFT               DATE,
  DLASTDATEINJOB          DATE,
  SNETZWERKLOGIN          VARCHAR2(11),
  SLOTUSNOTESNAME         VARCHAR2(30),
  SLOTUSNOTESVORNAME      VARCHAR2(30),
  SMIDNAME_NOTES          CHAR(1),
  SNAMEBUSINESSCARD       VARCHAR2(30),
  SMAILADDRESS            VARCHAR2(150),
  SNUMBERERNETADDRESS     VARCHAR2(50),
  SCOMPANYNAME            VARCHAR2(20),
  SCOMPANYTYPE            VARCHAR2(20),
  SCOMPANYSEGMENT         VARCHAR2(20),
  SCOMPANYUNIT            VARCHAR2(20),
  SDEPARTMENT             VARCHAR2(12),
  SDEPTTEXT               VARCHAR2(255),
  SKST                    VARCHAR2(15),
  SKSTDESCRIPTION         VARCHAR2(255),
  SBUILDING               VARCHAR2(20),
  SLOCATION               VARCHAR2(30),
  SOFFICEPHONENUMBER      VARCHAR2(30),
  SFAXPHONENUMBER         VARCHAR2(30),
  SCELLPHONENUMBER        VARCHAR2(30),
  STEL_SECRETARY          VARCHAR2(20),
  STEL_STELLVERTRETER     VARCHAR2(20),
  SADD_USER               VARCHAR2(50)          NOT NULL,
  DADD_DATE               DATE                  NOT NULL,
  SUPD_USER               VARCHAR2(50),
  DUPD_DATE               DATE,
  STN_NR                  VARCHAR2(10),
  ANREDE                  VARCHAR2(10),
  DUPDATEDBYAMS           DATE,
  DUPDATEDBYSAP           DATE,
  DUPDATEDBYLOTUSNOTES    DATE,
  DUPDATEDBYTELEFONIE     DATE,
  DELETEFLAG              NUMBER,
  DLASTNETWORKLOGINDATE   DATE,
  SERVICE                 NUMBER,
  NUSERROLE               NUMBER,
  BDELETESAP              NUMBER,
  BDELETEOA               NUMBER,
  SNAME                   VARCHAR2(100),
  DTDATEOFBIRTH           DATE,
  SDIRECTCELLPHONENUMBER  VARCHAR2(30),
  STELEFONIEDIREKT        VARCHAR2(30),
  STELEFONIEFAX           VARCHAR2(30),
  STELEFONIEMOBILE        VARCHAR2(30),
  STELEFONIEMOBILENUMBER  VARCHAR2(30),
  STELEFONIESEKRETARIAT   VARCHAR2(30),
  STELEFONIESTV           VARCHAR2(30),
  SNOTESTELDIREKT         VARCHAR2(30),
  SNOTESTELFAX            VARCHAR2(30),
  SNOTESTELMOBILE         VARCHAR2(30),
  DAPPROVECHANGE          DATE,
  SAPPROVEUSER            CHAR(10)

-- 
mfg
Marc Eggenberger