Hi,
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"
