Qlik Community

Knowledge

Search or browse our knowledge base to find answers to your questions ranging from account questions to troubleshooting error messages. The content is curated and updated by our global Support team

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS

Qlik Compose Data Warehouse Modeling Best Practices

cancel
Showing results for 
Search instead for 
Did you mean: 
TimGarrod
Employee
Employee

Qlik Compose Data Warehouse Modeling Best Practices

Attachments

Qlik Compose data warehouse projects provide end to end lifecycle
management of your data warehouse.   The model is a focal point as it provides the foundation for much of the ETL and data mart automation capabilities in Qlik Compose.

This technical paper is a guide to understanding Qlik Data Integration warehouse modeling design techniques and best practices for common business scenarios.

Labels (1)
Comments
vtatarnikov
Creator
Creator

Greate! Do you have a similar guide for data lakes?

TimGarrod
Employee
Employee

Compose Data Lake projects are purpose built to manage a pure ODS ("replicated copy of data") and HDS ("historical view of data changes - ie. Type 2") that typically conform to the source system. 

Consider a typical data lake architecture with 'RAW / Landed data' --> Bronze --> Silver --> Gold where the further "right" you go in the architecture, the more you implement transformation / curation of data.    Compose Data Lake projects are built to automate the "Bronze" layer of your data lake environment. 

Therefore there is no "modeling" concepts in Compose Data Lake like there is in Data Warehouse projects.    Typical lake implementations in Compose DL projects are handled with Discovery of metadata (which also pre-generates mappings), generation of code and then execution (followed of course by deployment 🙂 ).

Hope that helps

vtatarnikov
Creator
Creator

Thanks for the detailed answer

Version history
Last update:
‎2022-01-20 10:34 AM
Updated by: