How to do incremental load with out primary key?

[gireesh1216]

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

[m_woolf]

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.