Showing posts with label Qlikview interview. Show all posts
Showing posts with label Qlikview interview. Show all posts

Difference between ODBC and OLEDB in Qlikview

in one bite :: we commonly used functionality in qv while connect to db. here is the issue we know all of us use OLEDB why it is Preferable here i go with simple words...


ODBC : we can use this and access only relational database's such as oracle,mysql, mssql like,,
using we can't access old databases.

OLEDB : it's combination of Relational and non relational database's
it means the databases like XML,Mongo DB ,, (not only these)

Here look at Image for clear expo   Image  source

   

what is QVD and why

QVD stands for QlikView Document ( Data ) 

- QlikView Compressed Database File it is a flat data file with the extension .qvd. It saves an uncompressed RAM image representation of a QlikView table as it was stored in memory when open in QlikView, The applications reads data 100 time faster as compared to any other sources.