I am working on a developed app for a enhancement; this app has a complex model with many tables (using link table) so there is a table which has divisions like 1, 2,3 ... 6, now the requirement is to merge the dimensions 4 and 5 and call it 7.
I would like to know the best approach to deal with this , would it better to do it in the last layer of the data model ; if yes , please suggest how
or should we start the merge at the beginning of the loading of tables ; please note divisions for different regions are coming from different sources with a need of transformation in qlik