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
Autonumber
functionLearn 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