Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi There
I have below requirement.
I have 5 Tables
Table1
(ID -> Primary Key) - Fact Table
ID1
ID2
ID3
ID4
Table2 (ID1 ->Primary Key) -
Table3 (ID2 ->Primary Key)
Table4 (ID3 ->Primary Key)
Table5 (ID4 ->Primary Key)
Table 2 to 5 are connected with Table 1 using above respected ID's. How can we use this in one single QVD?
Thanks in advance,
Are you trying to save these 5 tables in a single QVD file? If you are then just perform a (Regular, Left, Right or Inner) Join operation to create one table out of the 5 and save them in a qvd.
If you're looking for a way to store an entire data model in a single QVD, why not store it in a headless QVW and perform a BINARY load whenever you need the data somewhere else?
Peter
Hi Peter
Thanks for updates , what is headless QVW?
Hi Ashish -
In general, an application is a QlikView file that is used as a ‘headless’ (i.e. UI-less) optimized application containing data– known as a .qvd file. it’s important for those responsible for the deployments to employ a multi-tiered data and application architecture approach
HTH
Sreeni
thanks Sreeni for updates, can you send me any sample file with mentioned criteria.
(I have created 5 different QVD's and then joining these QVD's with appropriate Primary keys)
Thanks Sunny.