I have used Incremental Load in my extractor QVW's.
For Insert and Update , its fine and also its reduced reload response time.
But if i used for delete purpose , almost its taking full load time.
for this..any one can give any suggestions?
Can u share your script?
have u checked in ur script? For delete purpose how much time its taking if we compare with full load?
its hard to tell without seeing the script, check with the linking keys and how your deleting the data ?? may be its taking hard time to find the key and delete it!!
Please paste your script that would to useful for us
sql load primarykey
As my analysis on incremental Load, If we implemented for Delete purpose it will take full load time.
Retrieving data ...