Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

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: