Summary
QlikView always desires a star schema as it is simple to understand and efficient for reporting. In this chapter, we learned different techniques of creating a star schema and converted our previously created data model into a star schema by using mapping loads, joins, and concatenation.
In the next chapter, we will learn about data modeling challenges, which are resolved by using cross tables, link tables, and the master calendar. You will also learn about handling slowly changing dimensions using the Interval Match function. Finally we will use QVDs to read and write our data model tables.
Get QlikView Essentials now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
