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)

    update_last_seq_id_parameter


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:

    (NOLOCK)

    WHERE accountid > $Pload_accounts_accountid$


4. Create a parameter:

    name: 'yourloadtable_yourid'

    value: some id

    comment: Last MAX accountid Processed


5. In your job:

    ……Some tasks…..

    execute update_last_seq_id_parameter (attached) this will capture the MAX accounted and will use it in the WHERE clause during next run