Incremental reload with a Composite Key as primary Key

[#1]

Hi All,

Greetings!!!

I need a script for incremental reload for Insert, Update and delete where we dont have single primary Key. Id I make a composite key with 4 fields then only It become primary Key.

Ex.

Load

A,

B,

C,

E,

F,

Last_Updated_Date

from TAB1.csv;

Here The composite key of A,B,C is primary key.

Please provide me the script.

Thanks in Advance.

Regards,

Veman Reddy

[sparur]

Hello, Verman

see an example of Incremenal Reload in http://robwunderlich.com/downloads/cookbook_V009.1.zip

Rob created a good example.

with composite primary key (A &'~'& B &'~'& C AS PrimaryKey) this approach is working too.