checksum incremental load

[Inderjeet Singh]

create table transac

(id int,

name varchar(100),

phone int,

checksum as checksum(name,phone))

---------------------

create table log_stage(id int, checksum int)

------------------------------------------

insert into log_stage

select ID,CHECKSUM

from transac

 

--------------------------

 

select t.*

from transac t

inner join log_stage s

on t.id = s.id

where t.checksum<> s.checksum