ETL reporting

didierodayo — Mon, 10 Oct 2016 22:19:57 GMT

Hello,

I am trying to build a table that shows all fields names and source table (after they were transformed /renamed etc..), all field names(from the extract stage) , and I would like to the show transformation expression (date; rename; etc..).

the objective is to make document review process easier.

an example is below:

Extract:

LOAD

NAME,

ADDRESS,

BOOKINGDT;

SQL SELECT *
FROM ECHO.BOOKING;

STORE Extract INTO (vPath)Extract.qvd;
DROP TABLE Extract;

Transform:

LOAD

NAME AS CUSTMERNAME,

ADDRESS AS "CUSTOMER ADDRESS",

BOOKINGDT as "BOOKING DATE"

FROM (vPath)Extract.qvd (qvd) ;

EXPECTED RESULT

topic ETL reporting in QlikView

ETL reporting