Cascade processing of QVD files.

Anonymous — Mon, 19 Nov 2012 17:01:14 GMT

Hello,

Let's say I have 2 views on database side ( Customer , Customer_LifeTime_Activity ) with following data :

Customer:

[c_id]

Customer_LifeTime_Activity:

[c_id], [value]

A 100

A 200

A 300

B 100

B 400

B 855

C 100

Extracts are generated from database views weekly. I use FastExport dump to file, and file import it's quicker then ODBC for Teradata. So in the end we have 2 calls of load utility :

LOAD

@1 as c_id,

@2 as value

FROM

C:\Users\sg0216851\Desktop\Travelocity\04_QlickView\Dir_struct\Prod\data\in\tableA.txt

(txt, codepage is 1252, explicit labels, delimiter is \x7, msq);

which we will save into QVD files to get "Customer.qvd" and "Customer_LifeTime_Activity.qvd". Now I want to move some logic implemented

in Teradata side into QlikView, for example :

SELECT

c.C_id, Count(*)

FROM

Customer c inner join Customer_LifeTime_Activity ca on c.c_id = ca.c_id

group by 1 ;

I now it's possible with QV, but it's not the point of discussion. I guess I need some back end process which will generate second level of QVD

files based on QVD extracts calculation. How can I implement that for command line purpose ? Second thing is error tracking, I want to return

log of QVDs processing into Teradata database via ODBC, is it possible with QV? Third thing which I want is implementation of easy QV report to

manage jobs ( QVD processing ). 😉

Thanks,

-R

topic Cascade processing of QVD files. in QlikView

Cascade processing of QVD files.