Which step should i do data model logic

[Anonymous]

Hi All,

What is the best practice of creating a data model from the beginning?

Below is my current flow of creating data model:

1. Connect to Data Source
2. Load table from Data Source
3. Store table as QVD file
4. Drop the loaded table
5. Load the created QVD file and apply logic like group by,apply map,form composite key,etc

Please advise if i would like to improve the performance of Qlikview project.

Many Thanks.

Best Regards,

Louis

[Anil_Babu_Samineni]

Till here, we are in good work. But, After that you may  remove Synthetic keys and Ref loops if any. Then, Business facts and transaction dimensions may understand to QIX engine.

[techvarun]

Hi Louis,

Below is the practice i am following.

1. Connect to data source
2. Extract the desired tables
3. Drop unnecessary/Unused  fields if any
4. Do all data transformations like (Where, ApplyMap etc)
5. Save the application as Application Backend.QVW
6. Binary load the "Application Backend.QVW" to main application and proceed to visuals.

QlikView first extract load and transform  the data on INLINE memory (RAM). So the creation of QVD and loading the QVD data again is a loss of time according to me.

In case if you really need the QVD files then create after transforming data.

Thanks,

Varun.

[Anonymous]

Hi Varun,

If i need to to use incremental load,

does qvd file is a must in this case?

If yes, what is the best flow?

Best Regards,

Louis

[arvind_patil]

Hi Louis,

Try to create data model in seprate qvw as well as follow below steps which mentiend above:

1. Connect to data source
2. Extract the desired tables
3. Drop unnecessary/Unused  fields if any
4. Do all data transformations like (Where, ApplyMap etc)
5. Save the application as Application Backend.QVW

Thanks,

Arvind Patil

[techvarun]

For Incremental Load,

You can alter your approach based on the scenario you are on.

Kindly refer the attached document.

Credits to the Original author of the Document

Thanks,

Varun