Thanks for your response.
I did perform incremental load and it works fine. Let me give a better background on the scene:
My application on an average fetches 10,000 records on every full reload from multiple databases in first layer.
When incremental load is performed, I get about 1000 new records (say about 1000 records from each table I’m using in the script) since the document was last loaded.
In Stage 2, all data sources are merged as one for Final Integration document.
Stage 3 contains the data model (and is also the end user application)
My end user application obviously has both incremental and historic data.
I want to create tables in a separate sheet here (GUI) that show these 1000 incremental load records (without historical data) from each of these tables.
In short, I need to limit my table by some condition (probably similar to the one I used in the script for incremental load) to show only incremental data without historic data.