• I guess you require this for incremental loading correct? Change Tracker is a summarized table which keep tracks of the tables with respect to the latest modified date. Simple way is to create a table which will have say 2 fields ie table name and latest_date column. Once you have calculated the delta then update this table with the max date. so always this table will have the latest date associated to the table name.

    Hopefully this answers your question.

    Thanks

    Rahul Sahay