Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I wonder if in QV apps i must use QVD for all my fact tables or only for those with long reload time?
Thanks
Thanks, for the moment i use qvd only for tables with >500 k records/year. I think i will stay others with SQL load.
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