It is always best practice to implementation have at least 3 layer because each app is disconnected if you need to run only extraction then you need to reload extraction rather then loading all 3 layers doesn't make sense. This is a reason why we are implementing 3 layers which is also best practice.
Feel free to close this tread with marking accepted solution if you are satisfied with answer.
Thanks
Vikas
Hope this resolve your issue. If the issue is solved please mark the answer with Accept as Solution & like it. If you want to go quickly, go alone. If you want to go far, go together.
There is no thumb rule that you have to use 3 tier architecture(ETL) only. You can use 2 tier architecture(ELT) or 1 tier architecture also.
It is you who have to decide which architecture you want to implement in your dashboard. Frankly speaking I use all kind of architecture in my project depend on scenario to scenario.
For example,
1: If you required only one table to develop the dashboard and that table already have all the aggregated measures, dimension then you can go with 1 layer architecture.
2: 2 tier architecture basically represent the ELT approach where you can perform the transformation of data while Extracting data from database to QVD or you can perform the transformation directly in final Load dashboard also.
Hope this will clear you query.
Thanks & Regards,
Prashant Sangle
Great dreamer's dreams never fulfilled, they are always transcended. Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
