Merge 2 data models in single qvw

[agni_gold]

Hi Friends ,

I have one situation where i have 200 million records since 2014 ,and i have created one data model using the fact and some dimension tables , now i am planing to split that data model into 2 part because it is taking lot of time ,

Previews Model

Current Year Model

After that i want to concat both qvw data in single qvw . everything will work fine but my dimension table data is getting duplicate.

How to avoid this situation , is there any solution for this or please suggest some other ways also.

[marcus_sommer]

I don't think that you will get any performance improvements from splitting a datamodel but keeping them as two separate datamodels within a single qvw - rather the opposite. The splitting itself will give you performance advantages if you then used two or even more qvw's - and you might use some simple kind of document chaining to enable the users to switch from one to another.

Beside this there might be further possibilities to improve the application performance by only loading needed fields and removing such things like record-ID's, splitting timestamps and of course avoiding aggr-functions and nested if-loops within the UI could speed up an application significantly.

- Marcus