Techniques that are used for creating data models in QlikView are as below:
Concatenate appends data from multiple data tables
- Forced : Concatenate
- Prevent :NoConcatenate
Join is used for consolidating the data from multiple tables into a single table
Mapping consolidates the data from a single field into a table
QlikView will perform better in
- Denormalized data storage
- Star Schema
This is due to shorter chain structure.
Above techniques help moving data models from normalized/relational structure towards denormalized/Snowflake/Star schemas.