Insert,update and Delete method in incremental load
Hi Team,
while i am implementing Insert,update and Delete method in incremental load, i could avoid deleted records but experiencing with duplicated records. So these duplicated records are not recommended.
Kindly let us know ,how can we avoid duplicates in Insert,update and Delete method with example.
But, Qlik will avoid duplicate records If we are seeing them in Tables
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
I have already gone through these links and all that made me expert in Incremental load.But still i could not get clarity on how to remove duplicates by using Delete method(3rd method) of incremental load. Kindly show me the example for removing duplicates by 3rd method.
In addition to that , Could we implement Insert and update(2nd method) method of incremental load by using Primary key(not using Date field). if yes kindly show sample example that would be greatfull!!
