I have a view in Oracle with around 50 tables and all have Last Update Date and Creation Date columns. If i get the view in Qlik Sense How can i load incremental data from view to Qlik Sense.
Thank you for the reply.
That view table has around 50 tables. Do i have to write incremental load for each individual table. Can i have some example code for understanding.
Hard to give a definitive answer without seeing the view & underlying table structures.
But probably you'll need to work against all the Last Update Date and Creation Date columns from all the tables.
You say you have 50 tables so I suspect most will be Dimensions and the rest Facts.
I would investigate the option of not extracting from the database view at all and go direct to the underlying tables. Many of the dimension columns could be better handled via a Qlik Mapping Table / ApplyMap().
In this case,the table size could be used as criteria. Use incremental for the large tables, and don't bother with the small ones.
What to consider small/large is up to you. I typically wouldn't use incremental load if full load takes less than a few minutes.