Optimization of models Flashcards
1
Q
Name the three guidelines of effective modeling
A
1) Identify recurring patterns
2) Split big models into smaller parts
3) Avoid monolithic views
2
Q
Should CDS views be mixed with calculation views?
A
No
3
Q
What is “Unfolding”
A
The art or desire to create a complete data flow in a single SQL statement
4
Q
When using SQL rather than the modeler, what is the recommendation
A
Use variables to make statements smaller and more readable. This reminds me of sub-selects
5
Q
What are the three types of partitioning?
A
Hash
Round Robin
Range
6
Q
How are partitions created in a column store
A
SQL statement CDS definition (recommended)
