Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I need to extract massive volume of data from an database using an incremental reload. This table is not indexed and daily i need to load last two day's data checking the update date field.
If i apply where condition to check the update date field, its checking the entire database and giving me the last two day's data. Is there a way to extract only last two day's of data without checking the entire database.
Please help on this..
Thanks in advance!
1. Store your update date in the variable like
Let vUpdateDate = Updatedfieldname
2. Then check this updated date in table like
Load * from Location Where Updatedfieldname > $(vUpdateDate);
Hi! Anand,
Thanks for the reply. I am doing the same way (Using where condition).
My question is, if i apply where condition it will search the entire database and check whether the condition is satisfied or not and then will extract the latest data. This process will take considerable time.
Is there a way to do the incremental reload without checking the entire database ?
Thanks in advance !
Hi.
Incremental reload is Performed based on Date field and a primary key.
I don't think you can perform incremental reload without where condition.
Hope it helps
Regards
ASHFAQ
In place or the date use primary keys and based on primary keys load the latest data. If primary key is not available then use composite keys.