Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Yatinder
Contributor
Contributor
‎2020-05-15 10:07 AM

How deal with Snapshot tables with huge dataset

Hi,

I have 8 tables which are getting loaded daily at database level and have more than billions of records. 

 

What logic we can apply so that after storing the data on Stage QVD, we should be ae to make sure that it gets updated daily. 

 

686 Views
0 Likes
1 Reply
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP
‎2020-05-15 10:08 AM

The best way is to use an Incremental load.

More info below.

https://help.qlik.com/en-US/sense/April2020/Subsystems/Hub/Content/Sense_Hub/LoadData/use-QVD-files-...

 

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
682 Views
0 Likes