Reload time Issue in Incremental Load(Delete)

[balasundaram]

Hi All,

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?

[ankit777]

hi,

Can u share your script?

[avinashelite]

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

[balasundaram]

delete:

inner join

sql load primarykey

from database;

[balasundaram]

have u checked in ur script? For delete purpose how much time its taking if we compare with full load?

[balasundaram]

have u checked in ur script? For delete purpose how much time its taking if we compare with full load?

[balasundaram · Accepted solution]

Hi,

As my analysis on incremental Load, If we implemented for Delete purpose it will take full load time.

Regards,

Bala