Techniques that are used for creating data models in QlikView are as below:
1) CONCATENATE
2) JOIN
3) MAPPING
Concatenate appends data from multiple data tables
- Automatic
- Forced : Concatenate
- Prevent :NoConcatenate
Join is used for consolidating the data from multiple tables into a single table
- INNER
- LEFT
- RIGHT
- OUTER
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.