Techniques that are used for creating data models in QlikView

    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

    1. Automatic
    2. Forced : Concatenate
    3. Prevent :NoConcatenate

    Join is used for consolidating the data from multiple tables into a single table

    1. INNER
    2. LEFT
    3. RIGHT
    4. OUTER

    Mapping consolidates the data from a single field into a table

     

    QlikView will perform better in

    1. Denormalized data storage
    2. Star Schema

    This is due to shorter chain structure.

     

    Above techniques help moving data models from normalized/relational structure towards denormalized/Snowflake/Star schemas.