Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.