Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP

Techniques that are used for creating data models in QlikView

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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.

Comments
Not applicable

Nice Info

0 Likes
Version history
Last update:
‎2014-11-12 11:45 PM
Updated by: