Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 6 QVD's that I created. I then took those QVD's and brought them into a new QVW to link them and create a data model. I want to then load that data model into a transformed QVD for use throughout the company.
But I realized I've never brought a whole model (ie multiple qvds linked together) into one QVD.
How do I do this?
Correct, you could join all the data into a single fact table, this isn't always the perfect solution since it can be RAM heavy, would a Binary load suit your load?
A QVD is 1 table, if you are talking about a binary load you can load multiple tables into another QVW by selecting table files and picking that QVW to open. It isnt a QVD and doesnt have the load optimization.
So if I have a QVW that I brought multplie QVDs into to make a data model, I can't then export that whole data model into one QVD?
Would the solution be to join all the QVD's into one table in my model?
Correct, you could join all the data into a single fact table, this isn't always the perfect solution since it can be RAM heavy, would a Binary load suit your load?
Binary load is what I'm looking for. Thank you!