ETL reporting

[didierodayo]

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