While creating Data Model we will do the below things
-->I hope Extract qvd's creation is completed
-->Now take the extracted qvd's into new qvw's do the calculations as per data Mapping document
-->gave Alias names which are understandable in Application.
-->Create variables for the convenience of calculation.
-->Create star schema or Snow flake schema in Data Model so that associating between the tables created and it will reduce Application refreshment time .
-->after created Data model use this as a source file for Application (which is visible to Business user).
and some more points are
Less Joins more comfort
Avoid Synthetic Keys
Circular Loops... No worries, Link Tables are our friends
Star or Snowflake.... Both are good but conditions apply*
Build multi tier architecture
Cleanse the data before Loading! Handle NULLs in data
Delete Unused Columns and Tables
Use Data Islands where necessary
Join, Concatenate or Keep?... Go with ApplyMap() over Join
Check Subset Ratio and Information Density at (Ctrl+T) table viewer
if you got the solution for your query,Please close this issue by clicking "Correct Answer"
