If your data is huge (means no of records) then go for qvd else you can used direct table from tables.
Great dreamer's dreams never fulfilled, they are always transcended. Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
There are a couple of key things that I have seen come into play in most cases, the time it takes to pull from a backend system being very slow due to size of the pull or geographic location potentially etc., but QVD can then be faster and contain just the incremental pull daily...
The other is when DBA's do not want you in their transactional systems pulling a bunch of records daily, and there is no data warehouse either. Just wanted to give you another way to look at things here, but there is no hard and fast rule really, entirely up to you if the time it takes to pull direct is about the same as the time to incrementally update and then read the QVD file etc., then the direct method should be fine, but if QVD takes a lot less time and you are in a time crunch, then that may be the better option.
The other rule that may be in play here is if it is not broke and nobody is complaining, do not try to fix it! 🙂
Cheers, Brett
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
.png "Former Employee"){kind=icon}
