topic ETL layer in qlikview in QlikView

ETL layer in qlikview

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

How to develop and design ETL layer in qlikview?

thank you..

Re: ETL layer in qlikview

vamsee — Wed, 24 May 2017 19:10:20 GMT

Hi Prachi,

Can you please elaborate your question.

ETL: -- Create 3 Apps

Extracting Data all your data with most basic filters.

Transforming your data according to a specific app or joining and creating qvd's.

Loading all your Qvd's into the final app with minor changes or joins, charts.

Re: ETL layer in qlikview

Digvijay_Singh — Wed, 24 May 2017 19:15:03 GMT

There are many topics here in community on this. You will find similar diagram as below explaining end to end process of Qlik Data Architecture development. In my opinion Qlikview 11 for developers book is the best resource to start with.

Re: ETL layer in qlikview

Anonymous — Thu, 25 May 2017 05:13:26 GMT

Advantages of III Tier Architecture

1. Reduces the load on databases/sources.

2. Load time of Dashboards is reduced because of the reduction in the source hits.

3. Data is consistent across all the Dashboards.

4. We can split the development process and assign it to multiple developers.

5. Very secure method, even we distribute the Qlikview file users cannot be able to find the source,

transformation details.

Disadvantages of III Tier Architecture

1. It takes bit extra time to develop.

2. Need to create more tasks in Publisher for reloading.

Re: ETL layer in qlikview

Siva_Sankar — Thu, 25 May 2017 05:38:09 GMT

Looks like you are preparing for some interview..all your questions in the community said it. You can better to learn from the learning materails and practice it then you ask questions.

SDLC in qlikview

compare Qlikview and Qliksense

Genric load In qlikview

ETL layer in qlikview

Preceding Load & Resident Load

Also, even after getting the answer you didnt mark any answers as correct for our fellow community contributors. Not good.

-Siva

Re: ETL layer in qlikview

avinashelite — Thu, 25 May 2017 06:10:50 GMT

Check this too

Extract, Transform, and Load

expressor : New QlikView Extension Released in expressor