Loading multiple source QVDs into one transformed QVD

[#1]

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?

[#2]

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.

[#3]

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?

[#4 · Accepted solution]

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?

[#5]

Binary load is what I'm looking for. Thank you!