This process can work for both Microsoft SQL Server & Oracle. There are separate attachments for each of these.
Steps to Implement Incremental Load by ID
1. Create a custom procedure (code attached)
2. In load table job description enter something like this:
Where accountid is the column name of the sequential id.
3. In Where Clause (Source) add:
WHERE accountid > $Pload_accounts_accountid$
4. Create a parameter:
value: some id
comment: Last MAX accountid Processed
5. In your job:
execute update_last_seq_id_parameter (attached) this will capture the MAX accounted and will use it in the WHERE clause during next run