Chapter 4. Data Modeling Challenges
In creating a data model, you will come across challenges in terms of different formats of data, loading multiple fact tables, and performance issues. There are techniques to resolve these challenges.
In this chapter we shall:
- Learn about loading a Crosstable
- Learn about the
Autonumberfunction - Learn about creating a link table to load multiple fact tables
- Learn about variable overview
- Learn about creating a master calendar
- Handle SCD using IntervalMatch
- Store and read data from QVDs (QlikView data files)
- Learn about optimized load
- Discuss best practices for data modeling
