4 Replies Latest reply: May 5, 2010 2:16 AM by msn_manju RSS

    Question: How to do incremental load of QVDs

      I have a DB which has many tables in it. Data is inserted, updated and deleted on a daily basis. I have few QVDs setup that pulls data from these tables twice daily. Then there are many QVWs that reads data from these QVDs. My problem is that data pull from DB to QVD (complete load) is taking a long time (about 2 hours now) and its increasing with each day. Is there a way to pull only those records from DB that are inserted, modified and deleted and update the DB incrementally?