ETL ( QlikView)

[#1]

Hi QlikView Experts,

I am new in QlikView I am trying to be familiar with this product I heared that QlikView is having ETL thing i

is it ?  can anyone explain me how ..

Regards

Bhuwan

[its_anandrjs]

You can do the ETL with the qlikview application and refer this manuals

ETL-Tools_QlikView_Connector_User_Manual.pdf

ETL-Tools QlikView Connector

And refer this also

ETL details and  Overview

[whiteline]

Hi.

Read the QlikView reference manual.

[sujeetsingh]

ETL Concepts as:

---Option to load data as temp tables

---functions to implement your logic

---One can implement Data ware house concepts as Star schema

--

--

--

A lot more so just follow Reference manual.

[its_anandrjs]

You can do ETL from your own way like

Extract

1. Read the raw data in the qlikview application.

Transform

2. Read the raw data and transform the field in a meaning full way using various functions and apply to tables.

Load

3. Read the transform data and loading the data according to business logic or create a data ware housing concepts.

[jagan]

Hi Bhuwan,

You can transform the data like Other ETL tools do using Qlikview Scripting.  If you want you can also Expressor tool for Qlikview ETL also.

You can use normal SQL queries to load the data into Qlikview, and if you are using any Flat files then you have to use LOAD statement of Qlikview.

In Qlikview there are many in built transformations available like CrossTable(for unpivoting), IntervalMatch, Mapping Load for Lookup, Generic load, Joins like LEFT, RIGHT and INNER, etc.

Refer Qlikview Reference manual or you buy Qlikview 11 for Developers, in this books you can find more details.

Hope this helps you.

Regards,

Jagan.

[#7]

Thank You I will read it.

[#8]

Thank You I will read it.

[#9 · Accepted solution]

Thank You Jagan.

[#10]

Thank You Guys ..for your valuable informations.