How to do incremental load with out primary key?

gireesh1216 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All

How to do incremental load with out primary key Field...Any Idea?

Please Help Me

My script:

let vQvdcreateTime=qvdcreatetime('path of qvd');

Load Empid,App_Request,Date_Request,End_Request from employee where Date_Request >=vQvdcreateTime;//loading new data

concatenate

Load Empid,App_Request,Date_Request,End_Request from employee from employe.qvd(qvd) where not exists(?????);//old data

which field i need to use in where exists ??// Above table Empid not a primary key

Thanks

Gireesh

Re: How to do incremental load with out primary key?

m_woolf — Tue, 11 Oct 2016 16:36:46 GMT

If you have a Date or Timestamp field, you can use that for your incremental load.

When you do a load, store the max(Date) or max(timestamp) in a variable. Then on the next load, load all since variable value.